A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Reports and E-mail.



 
 
Thread Tools Display Modes
  #1  
Old September 23rd, 2008, 07:17 PM posted to microsoft.public.access.tablesdbdesign
Timothy Millar
external usenet poster
 
Posts: 24
Default Reports and E-mail.

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.
  #2  
Old September 24th, 2008, 04:36 PM posted to microsoft.public.access.tablesdbdesign
Armen Stein
external usenet poster
 
Posts: 507
Default Reports and E-mail.

On Tue, 23 Sep 2008 11:17:00 -0700, Timothy Millar
wrote:

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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:35 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.