Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
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
Novice
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
.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
Reply With Quote
Reply

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.
MSOfficeForums.com is not affiliated with Microsoft