#1
|
|||
|
|||
Changing font for an Outlook email in VBA
Hi all.. Can anyone tell me how I might change the font of the entire body of an email after it has been created using VBA? I've copied parts from a Word document and other parts from a database in Access (which is running the show). I have code such as:
With wrdApp.Selection .WholeStory .Font.NAME = "Courier New" .Copy End With olMessage.Body = wrdApp.Selection olMessage.BodyFormat = olFormatRichText olMessage.Display I would also like to be able to put the data in evenly spaced columns but it seems the Courier New font would accomplish that. (The user doesn't want an attachment. He wants the whole thing in the body of the email.) Any ideas? Thanks in advance...Glenn |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge to email, changing images on email layout | ginelli | Mail Merge | 18 | 02-23-2013 09:47 AM |
Changing font in VBA | blaze | Word VBA | 1 | 04-15-2012 02:21 AM |
Font changing in new message | geezawolf | Outlook | 0 | 01-11-2012 08:56 AM |
Font changing in text box | mschmidt | Word | 7 | 10-20-2011 02:05 AM |
changing font size without changing leading | carolns | Word | 1 | 09-14-2009 12:30 PM |