SendObject with multiple objects

[dveer]

I want to send a report in 2 different formats (SNP and HTML) in a single
email.
With the following code I can send a single file, but I do not know how to
add the second attachment in the same mail:

DoCmd.OpenReport "Rpt_test", acViewPreview, ,
DoCmd.SelectObject acReport, "Rpt_test"
DoCmd.SendObject acSendReport, "Rpt_test", acFormatSNP, , , , "Test
fileâ€, "Attached is a test file", True
DoCmd.Close acReport, "Rpt_test", acSaveNo

 

[Alex Dybenko]

Hi,
not sure you can do so using DoCmd.SendObject, but you can save both files
to some temporary folder and then send both attachments using outlook like
here for example: http://www.mvps.org/access/modules/mdl0019.htm

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com