Reports and E-mail.

[Timothy Millar]

I have a report that I have set up to be e-mails. I can place information
into the SUBJECT field and I can place text in the body of the e-mail but I
need to be able to use different fonts, font sizes, bold, highlights, etc.
Is there a way to do this?

I use Microsoft Outlook 2003 and Access 2003. Thank you.

 

[Armen Stein]

I have a report that I have set up to be e-mails. I can place information
into the SUBJECT field and I can place text in the body of the e-mail but I
need to be able to use different fonts, font sizes, bold, highlights, etc.
Is there a way to do this?

I use Microsoft Outlook 2003 and Access 2003. Thank you.

You may want to look into Word merging to do this. Word allows you to
set up a merge document that can be emailed to a list of recipients,
one at a time. That way each one can say Dear Timothy, Dear Armen,
etc. You also get full formatting.

All of this can be automated from Access using VBA if desired - you
would want to search for topics on Word merge automation using VBA.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com