Sending automatic e-mail report with variable in "Subject"

V

Vivi

Hi. I have one main form with one subform (keep multiple e-mail address)
linked by ID.
I use the following method to generate e-mail without no problems.

DoCmd.OpenReport "Myreport", acViewPreview,,"ID="&CINT(ID), acHidden
DoCmd.SendObject acSendReport,"Myreport",acFormat rft,
"(e-mail address removed)",,"subject", "message",False
DoCmd.Close acReport, "Myreport", acSaveno

1. But, in the mail subject, if I want to put: The invoice number (ID) is
changed", the ID will be the variable, how can I do it???
2. If I only want to send e-mail to those who in the subform, how can I do
it???

Thanks.
 

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

Supress sending rtf to printer 3
report in a loop 4
Individual Report to each Staff member 0
Dynamically Name the report attached to email? 1
How to use "variable" in Subject and Send to in Access E-mail 1
Adding date at the end of report name 1
SendObject with multiple objects 1
Printing incremental number on report. 5

Top