Email Multiple Reports

[MyWaterloo]

I am currently using...

 DoCmd.SendObject acReport, BactPDF, acFormatPDF, Me.Text199, , , "BacT Results " & Me.Report_Heading

...to email my report. I have now come up against a need to send multiple reports on a single email. How is this done? The SendObject command seems to be designed to only send one report per email. How do I send more than one pdf report on a single email? Ideas?

Thank You

[nico5038]

Check out the code from pianoman in:

http://bytes.com/topic/access/answers/851896-insert-email-attachment-using-vba

This will allow multiple attachments.

Nic;o)

[MyWaterloo]

Thank You. That works... almost. The problem is that my files that need sending will not always have the same name. Is there anyway to have the file name pulled from a field on my form?

Set objectlookAttach = .Attachments.Add("C:\Temp\[Me.BacTName].pdf")

Where the data in the field [Me.BacTName] is what the file will be named. This code doesn't work like this, but it does show what I am trying to do.

[NeoPa]

Nearly there :-) Try this instead :

Set objectlookAttach = .Attachments.Add("C:\Temp\" & Me.BacTName & ".pdf")

[MyWaterloo]

Of course! Using "&". Thank you! It works fabulous now.

[NeoPa]

No worries. Don't forget to set Nico's post as the Best Answer ;-)