Fill body of emai with data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

Is it possible to send an email from Access where the body of the email has
the content of a report (or query, or table) instead of sending an attachment?
In other words, in the body of the emai it would show:
Project ID: 1275
Submitted By: Marc
Priority: Urgent
etc.

I'm trying to send this from a form after the data has been entered.

Thanks,
 
Not in a report that I know of, but you can use the Mailto:
method from VBA to send e-mail wherein you can insert whatever
data you want in the body of the e-mail. If that approach
doesn't get the job done the way you want, you can use
Lyle Fairfield's SendMailWithOE to send whatever you
want including attachments.
Bill
 
Thanks Bill.
--
Marc


Bill said:
Not in a report that I know of, but you can use the Mailto:
method from VBA to send e-mail wherein you can insert whatever
data you want in the body of the e-mail. If that approach
doesn't get the job done the way you want, you can use
Lyle Fairfield's SendMailWithOE to send whatever you
want including attachments.
Bill
 
Back
Top