Sending .pdf in Outlook

[Stephanie53]

I am just trying to email customer just a copy of his invoice and when I looked at the attachment it brought up all the invoices for every customer in our database. I changed it to print up Form and now it wont attach anything in email.



Please advise to what I am doing wrong

TIA!

[pbaldy]

Somehow the report needs to filter itself to the record on the form. A parameter query is one way, this is another:

http://www.granite.ab.ca/access/emai...recipients.htm

[Stephanie53]

Ok unfortunately that link has me all confused. Can you advise to where I would put this filter? I have the form in design view and looking under the properties of this field I only see FilterLookup.

I look under CustomerExtended Query and still not sure what to put in there...can you give me an example? the examples that is at that link unfortunately doesnt help me as that isnt telling me where to go to other then need to create Filter too.

I need it to email it out in PDF...got that working fine in the Macro...all I want to do is email only ONE invoice that is attached to that customers order...not everyone elses invoice too..is that part of the Macro somewhere that I am missing? Is there a VBA Code for this that I am missing?

Sorry for so many questions just getting frustrated here :-(

TIA!

[pbaldy]

From the link: "Therefore you must change the filter or where clause yourself in the reports OnOpen event."

If you want to use the query, you'd put a criteria pointing to the form under the appropriate field(s).

[Stephanie53]

What version of Access has OnOpen in the Events? Because in Access2010 I dont see it...maybe that is why I am confused here?

[pbaldy]

You're looking at the properties of a textbox. You want the properties of the report. You want to email a report, not a form; you have a lot more control over the formatting in a report.

[Stephanie53]

in the properties under the report under On Open (Embedded Macro) but when I open that its blank. Now what?

[pbaldy]

The method I posted is VBA, which would go here:

http://www.baldyweb.com/FirstVBA.htm

[Stephanie53]

Me.Filter = "ShipmentsID=" & Forms![Select Load List]![LoadID]
Me.FilterOn = True

Now here is the qestion...as I am not sure of the VBA for my issue so treat me like i am huge dummy when it comes to VBA Coding:

You said to do it where it says OnOpen
Under OnOpen is (Embedded Macro) with nothing in it.
Do I put it somewhere else or get rid of the (Embedded Macro) and put it OnOpen event?
Secondly - I dont think that code above will work for me as I am not sure what a "ShipmentsID=" is nor do I know what to type in after that.

My report name is Invoice

Can you help me out and tell me the correct way to type this code? What do I change in the above code that will work for me?

[Stephanie53]

and just FYI...I am using a Template and just entering in all the pertanent info (i.e. customers, products, supplies, employees) in the tables prvided and using the predetermined reports as well as it seems my VBA knowledge really sucks.

[Stephanie53]

ok this is what i got so far...

Private Sub Report_DblClick(Cancel As Integer)
Me.Filter = "Invoice=" & Forms! (what do i select here?) ! (what do i do here?)
End Sub

[June7]

I open filtered reports using WHERE argument of DoCmd.OpenReport. I don't use macros so the VBA is like:

DoCmd.OpenReport "Invoice", acViewPreview, , "ShipmentsID=" & Me.LoadID
DoCmd.SendObject acSendReport, , acFormatPDF, "email address", , , "Invoice", "email body text"

[Stephanie53]

Hi June!

Ok here is the problem with that...

DoCmd.OpenReport "Invoice", acViewPreview, , "ShipmentsID=" & Me.LoadID
DoCmd.SendObject acSendReport, , acFormatPDF, "email address", , , "Invoice", "email body text"

Where its highlited in RED is throwing me off...
The only thing I have on this Report is Order ID and Product ID that says ID in the name Do I change what is in RED to those?

[June7]

Use whatever criteria gets the report to open with desired recordset. If that is OrderID then use OrderID. Actually, I would have thought there would be an InvoiceID because you are printing an invoice. But since I don't know your data structure, I can't be specific. I was only following criteria examples in previous posts.

[Stephanie53]

Ok lets start all over here because it seems that anytime I ask for help its becoming a huge project to get the answers as I need them. And each time I think I explain what it is that I need help with with...but since I am not as knowledgable as you all it would help if you are not sure what it is that I am trying to do to ask me the questions in return that is needed to get the help here that I need ...so maybe if I explain exactly what I am trying to do and when I want it done then maybe we can get this worked out together here :-)

Now first off...I am running Access 2010 - so sending me links for any version prior is not going to help me...wasted alot of time with that earlier. And I would have thought that it says which one i am running under my name I would be able to get support for my version :-))

Here is what I am trying to do...

Customer calls in an wants to place an Quote/Order for the product. Now before we can submit it as an order they MUST have a Quote for approval. Now I bring up the Quote/Order Form. Sales puts in customers info. Then they select the products that the Customer wants. After which then the Sales can double click on the Customers email on trhe Quote/Order Form to which it will bring up Quote/Invoice as a PDF and attach itself to email to the customer.

Now here is what is on the Quote/Invoice that we call it but in reports we call it "Invoice"

and now that I have put in the VBA Codes that you all have suggest...now I cant even get the Invoice up at all. I am getting RUN TIME ERRPR 2427: You have entered an expression that has no value.

I have tried the following as suggested:
DoCmd.OpenReport "Invoice", acViewNormal, , "Product_ID" & Me.Order_ID
DoCmd.SendObject acSendReport, , acFormatPDF, "email address", , , "Invoice", "email body text"

Then tried the following:
DoCmd.OpenReport "Invoice", acViewNormal, , "Order_ID" & Me.Product_ID
DoCmd.SendObject acSendReport, , acFormatPDF, "email address", , , "Invoice", "email body text"

Now I didnt name these things...Northwinds Trader did. I thought it could be seen in the Pics I posted above..

Where as before I was able to get the Invoice, I was able to email and attach PDF thru the Macro that I created but unfortunately I was sending EVERY Invoice to one customer.

I know that there must be somewhere that says to ONLY send for that customer THAT Order somewhere in the program somewhere...but I am stumped on where and how to put it to get this work.

I really mean this from the bottom of my heart and not being mean or ficisious when saying this. You all are doing your best to help me..adn you have shown great patience in not kicking me off here..yet!! lol but I know I have said several times here in the forums...Treat me as if I NEVER touched Access before and guide with me kids hands thru this process please. If you tell me to put something somewhere please be a little more detailed..and please make sure that we are talking about the same version of Access and not send me to things that work for 2003 and 2007 but not compaitable with 2010. And if your not sure what I am talking about...please ask me the right questions so I can get to you what you need to know to help me.

So what I said above..does this help you understand what it is that I need help with? and if not what else do you need to know to assist me with this..

Thanks again for all your help and support in this

Stephanie