how to attach more than 1 access report to an email using sendobj.

G

Glasgow

Using sendobject I can attach a single report in Snapshot Format to an email
but I would like to be able to attach 2 to the same email. Anyone know how to
do this ?
The code I use is currently
DoCmd.OpenReport "Translation_QuoteAcceptance", acViewPreview, ,
"[ProjectID]=[Forms]![translation2005]![ProjectID]"
DoCmd.SendObject (acSendReport), "Translation_QuoteAcceptance", "Snapshot
format", Forms!translation2005!Contact_Email, , , "Translation Quotation",
"Thank you for providing us with the opportunity to quote for the translation
of your document."
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SendObject with multiple objects 1
send an object as an attachment 1
Email attachments 4
EMailing a report in Access 2003 3
Send Report using email 0
send two attachments using sendObject 1
Auto Email Feature 1
VBA to look for more than 1 key word and highlights 8

Top