adding several reports as attachments to e-mail

[wsuess]

i have the problem that i want to send an e-mail with two or three reports as attachment. i tried with

dim xxx as outlook.attachments
xxx.add <report-name>
xxx.add <report-name>

... but it didn't work, because vba wants the full path of the file, but it isn't a file !!! its just a report in my database

has anyone a solution?

Wolfgang Suess

 

[p27br]

hello

have you tried docmd.sendobject acreport ... ?

 

[wsuess]

yes, i tried, one report as attachment is no problem - works perfect, but two reports ...