docmd.sendobject sending in wrong format

kshope25

Registered User.
Local time
Today, 00:43
Joined
Mar 1, 2012
Messages
29
I have the following code tied to a command button in access. I know the code is right b/c it'll generate the email and attach a file in my lotus notes, however, the attachment is not in a pdf format. Even when i take the acformatPDF out of the code below and I chose PDF from the prompt, it still attaches in some weird format that looks something like this.

- {D8EF2E32-9D5F-4A3A-8AAB-3F7608D5247B}

What am I doing wrong? Code Below:


Private Sub sendskidlabels_Click()
DoCmd.SendObject acSendReport, "rpt_skid_label_current", acFormatPDF, , , , "Skid Labels To Be Used For NAIL Shipments Effective Week Beginning 6/17/13"
End Sub
 

Users who are viewing this thread

Back
Top Bottom