Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 08-23-2013, 02:56 AM
Glenn_Suggs Glenn_Suggs is offline Changing font for an Outlook email in VBA Windows 7 64bit Changing font for an Outlook email in VBA Office 2010 32bit
Changing font for an Outlook email in VBA
Join Date: Jul 2013
Posts: 4
Glenn_Suggs is on a distinguished road
Default 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
.Font.NAME = "Courier New"
End With

olMessage.Body = wrdApp.Selection

olMessage.BodyFormat = olFormatRichText


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
Reply With Quote

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 for an Outlook email in VBA 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

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 09:20 PM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd. is not affiliated with Microsoft