Emailing Objects with Groupwise 2014

Question

I have Access 2010 and a report that I would like to email using Groupwise 2014.

i have tried using the EmailDatabaseObject macro.  Access will bring up a new email, but it will not attach the report in any format.

I have also tried using the following code, but it gives me a compile error... I'm not a VBA programmer so I am just using what I found on the MSDN webpage.  If I remove the ( ) it will run the report and bring up an email, but again.... no attachment.  I have PDFCreator as a printer, but it only creates the PDF, it doesn't give me the option to email it. 

Private Sub btnReportEmailPDF_Click()

DoCmd.SendObject(acSendReport, Report_RptTESTSendPDF, acSendPDF, , , , "Test File in PDF", "This is a PDF test", True, )

End Sub

Answer 1

I meant to add:

objMessage.AddAttachment

is used to add attachments.

http://www.devhut.net/2014/06/10/how-to-send-multiple-attachments-within-a-single-e-mail-using-vba/ has some details.

Answer 2

This would work since it runs against the server directly, but I don't know if you can make it work using your VBA skills. Make sure you use the correct smtpserver, sendusername, sendpassword.

http://p2p.wrox.com/access/35650-email-attachment-vba.html