Sending .pdf in Outlook

[June7]

Believe me, we are doing our best to try and understand your issue. I ask questions when I don't and I think we do understand what you want but conveying instructions not always easy in print.



I disagree about referencing code produced under older versions. VBA hasn't changed much and ideas can be derived from examples.

I don't see Order_ID on the form image except referenced in textbox expression.

Missing = sign; try ! instead of . referencing Order_ID (really, either should work):

DoCmd.OpenReport "Invoice", acViewNormal, , "Order_ID=" & Me!Order_ID

If that fails, use [] because the field names really have spaces, not underscore:

DoCmd.OpenReport "Invoice", acViewNormal, , "[Order ID]=" & Me![Order ID]

That code assumes Order_ID is number, not text field.

Use a real email address in place of "email address" or maybe a reference to control name on form (just guessing about name): Me.Email

It might be necessary to commit the record entry/edit to table before it is available for the report output.

DoCmd.RunCommand acCmdSaveRecord

Learn debug methods. Refer to link at bottom of my post for VBA debugging techniques.

[Stephanie53]

Thank you again June...but its still not working...

The Field has spaces so I used the following:

DoCmd.OpenReport "Invoice", acViewNormal, , "[Order ID]=" & Me![Order ID]

Kept getting debug error...so I went to the Invoice Table that this is taken from and went into Design View..I did see Invoice ID in design view but not in Data View (first off what is that?) And yes they are both a number...

So then I tried the following:

Private Sub Report_Open(Cancel As Integer)
DoCmd.OpenReport "Invoice", acViewNormal, , "[Invoice ID]=" & Me![Order ID]
DoCmd.SendObject acSendReport, , acFormatPDF, "email address", , , "Invoice", "email body text"
End Sub

no more debugging...but still cant get the PDF to attach to email. Now before I was told to do it on OnOpen in events. Should I try doing it when we Double Click on Email?

[June7]

Why would you have code to open report in that report's open event? That's just not logical. All programming is an exercise in logic. Yes, the code I offer would go in event behind form. Could be a button Click or box AfterUpdate or DoubleClick. Whichever is most convenient and appropriate for the user because don't want report to run before all data is committed to table. I edited previous post regarding the commitment issue, in case you missed it.

[Stephanie53]

Ok now we are getting somewhere somewhat...

I changed it to OnDblClick ..I am able to view the ONE invoice. But when I go to email and double click on it then it attaches all invoices that not only belongs to this customer it also attaches every invoice of other customers too in PDF.

How can I get it to ONLY attach the ONE invoice in email?

[Stephanie53]

DoCmd.RunCommand acCmdSaveRecord where do i put this at? under what event?

[June7]

Save record in same event code, just before OpenReport

What do you mean by "go to email and double click on it" - double click on email?

The code should open report then open Outlook with the report attached as a PDF and the PDF should have only one invoice. Works for me.

I give up. Provide db for analysis.

[pbaldy]

You don't specify the report in the SendObject line, which I would do. Can you post the db here?

[June7]

If report is not specified, code will use the opened report. Works for me.

[Stephanie53]

Database5.zip

Ok now when you open go to LOGIN go to Charles Fulbright name

Click on New Customer Order

Select Tate Supply as customer

Select any product that has any quanity in it to sell

You will get a popup Expression Error and just exit out of that debugging (dont worry I know what that issue is..but I am waiting on some people here to get me the correct information for that before I go on and fix that issue)

Then go to shipping and select any shipper (which I have to figure out how to change this option as it wont let you create invoice without it and there are times when we have to send this to customer without the shipper info at that time)

Click on Create Invoice and you will see only the ONE invoice shows up

Then double click on the email address and watch it go crazy :-)

Let me know please on what you can do for me :-)

And thank you BOTH!! :-)

[pbaldy]

I guess somebody bailed? You've got an embedded macro there, not the suggested VBA code. This works:

DoCmd.OpenReport "Invoice", acViewPreview, , "[Order ID]=" & Me![Order ID]
DoCmd.SendObject acSendReport, , acFormatPDF, , , , "Invoice", "email body text", True

[June7]

Bailed, not quite, just gave up trying to analyse from post narrative. I have limited use of Access 2010 until I fix or replace my computer. The file wouldn't open for me under 2007.

Be sure to select [Event Procedure] in the event property if you want to use VBA. Then click the ellipses (...) to go to procedure in VBA editor. I looked for the VBA code I suggested but it isn't there.

I followed your instructions but when I click Create Invoice get message "Cannot create invoice! Inventory has not been allocated for each specified product."

[Stephanie53]

June, its because you selected a product that either didnt have any in stock or you didnt select quantity. I am trying everything you all said and I will let you know if it works :-)

[Stephanie53]

Paul,

where did you see the embedded macro? Also, do I put the code you posted under the properties of Invoice or Order Details?

[Stephanie53]

June,

It was under Order Details in the Properties of that form. Did I put it in wrong place?

[pbaldy]

Paul,

where did you see the embedded macro? Also, do I put the code you posted under the properties of Invoice or Order Details?

I believe it was in the double click event of the email address. Code goes here:

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