Sending emails with stationary

  • Thread starter Thread starter Deborah
  • Start date Start date
D

Deborah

I want to send e-mails to a number of selected individuals
chosen by a query run in Access. So far I have been able
to run the query and produced the Word document which is
sent as an attachment. However, the message area of the
email is blank and this really needs to have something
added to it, such as info "if you cannot read the attached
document please call us on xxx xxxxxx.

I've designed Stationary (linked to Front Page)and set
this as the default for all out-going emails. This works
if an individual email is sent via Outlook Express,
however it does not appear when the merged emails are sent.

Help please!
 
To include text you use the format...

DoCmd.SendObject acSendReport, , "snapshot format", (e-mail address removed), , ,
"Some Report Name", "Attached is a report" & Chr(10) & "If you cannot read
the report, call me.", False


This command sends a report in snapshot viewer format. You can do similar
with queries and send it in rich text format. Just use the help features
for more details on the sendobject command.

DoCmd.SendObject [objecttype][, objectname][, outputformat][, to][, cc][,
bcc][, subject][, messagetext][, editmessage][, templatefile]


Hope that helps.

Rick B




I want to send e-mails to a number of selected individuals
chosen by a query run in Access. So far I have been able
to run the query and produced the Word document which is
sent as an attachment. However, the message area of the
email is blank and this really needs to have something
added to it, such as info "if you cannot read the attached
document please call us on xxx xxxxxx.

I've designed Stationary (linked to Front Page)and set
this as the default for all out-going emails. This works
if an individual email is sent via Outlook Express,
however it does not appear when the merged emails are sent.

Help please!
 
Back
Top