automate dates in outlook template

Not open for further replies.



Using Outlook 2010 I created two templates that goes out to certain recipients every day.

The first template is used for the e-mail that goes out Tuesdays – Fridays & will have the following for the Subject/body:

Subject: report for: <today’s date> in “mm/dd/yy” format

Body of e-mail:

…my text: <yesterday’s date> “mm/dd/yy” format

…my textg: <today’s date> “mm/dd/yy” format

The second template is used for the e-mail that goes out on Mondays & will have the following for the Subject/body:

Subject: report for: <today’s date>

Body of e-mail

…my text: <Friday’s date> and <Saturday’s date>

….my text <today’s date

my goal is to update the dates each time I open my templates. For this, I used the attached code which works fine. However, how can I format my text (font, bold etc.) as in the (attached) sample?



  • Sample template.doc
    30 KB · Views: 634
Try <b></b> around the words. Set the item.body to item.HTMLBoday. You may also need to use <br /> instead of the vbCR.

Text_TF = "…I ran the report <b>using</b>: " & Format(Date - 1, "mm/dd/yy") & _
vbCrLf & "<br />….I ran this report using " & Format(Date, "mm/dd/yy")
MyItem.HTMLBody = Text_TF

changing fonts uses a similar method.
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
M Outlook macro to automate search and forward process Outlook VBA and Custom Forms 6
S automate save the .xlxs file to share Network Using Outlook 1
P Automate Outlook Start - No Active Explorer Object Found Using Outlook 10
C Further automate several tasks with rule, VBA or Quick Step Using Outlook 1
K Automate permamnent delete after x days with exceptions Using Outlook 1
T Automate Outlook 2010 Using Outlook 4
S How to automate showing the Public Folder Calender to Mail Favorite folder Using Outlook 0
S CSCANPST To Automate Running SCANPST.EXE Using Outlook 1
J OL2003 Macro disables itself - looking for way to automate 'enable' Using Outlook 2
S Automate saving of attachments on new incoming emails Outlook VBA and Custom Forms 3
B automate email message on Outlook Calendar notification alerts? Outlook VBA and Custom Forms 1
S automate outlook stationary Outlook VBA and Custom Forms 1
Q Automate Outlook profiles for imaging Using Outlook 2
Q Automate BCM backup? BCM (Business Contact Manager) 1
P Outlook tasks keeps changing (updating) dates that I type Using Outlook 2
V Why is "Value Required" checkbox greyed out for Dates? Outlook VBA and Custom Forms 2
L dynamic and static dates in Outlook contact "notes" ie. body Using Outlook 2
I Help with dates in task list. Using Outlook 5
Z Outlook for G Suite emails showing wrong dates Using Outlook 4
Z Outlook 2013 Gmail IMPA emails not showing dates only showing times Using Outlook 1
J Outlook 2013 Extract Flag Completed dates to Excel Macro Outlook VBA and Custom Forms 16
O Outlook 2016 follow-up flags--how can I add dates? Using Outlook 1
L Entering dates in Contacts and Calendar Using Outlook 4
O highlighted dates in Yearly View for Outlook 2010 Using Outlook 1
B Extract Dates for Appointment Item in Body of email Outlook VBA and Custom Forms 10
1 Incorrect dates in sent folder Using Outlook 4
C Many Expiration Dates in Custom Form Using Outlook 1
N To Do bar showing incorrect due dates on tasks Using Outlook 4
R adding anniversary dates in outlook Using Outlook 2
B Birthday dates automatically (and improperly) placed in Birthday Details Using Outlook 2
D Task Start and Due Dates Using Outlook 3
T Conditional dates in Outlook Calendar Exchange Server Administration 1
C Dates changes to 1899 when Tab key hit in Time... Using Outlook 3
C dates missing when importing emails Using Outlook 5
S Inserting Dates With Quick Parts (or Macros) Using Outlook 4
K Recurring Tasks on specific dates, not pattern Using Outlook 0
S Reminders and Due Dates in Outlook 2010 Using Outlook 6
D Sending Multiple Meeting Dates in One Meeting Request Using Outlook 4
A Is there a calender preference for Julian Dates in outlook? Using Outlook 4
T comparing and subtracting sent and received dates Outlook VBA and Custom Forms 3
D offline fatabase on laptop not remembering TASKS dates BCM (Business Contact Manager) 1
J Get Dates of Recurring Events in Shared Appointment Calendar Outlook VBA and Custom Forms 4
Y The New Outlook - Q's & Thoughts Using Outlook 2
M Start Outlook 365 at unified inbox Using Outlook 2
B Requesting VBA code to make Outlook prompt for confirmation when deleting a task? Outlook VBA and Custom Forms 3
T In-line reply style in Outlook II Outlook VBA and Custom Forms 1
G Outlook Contact Item.Restrict where FullName is NULL Outlook VBA and Custom Forms 3
J Emails with .ICS calendar invitations attached don't contents when received in Outlook 365 Using Outlook 6
W Outlook 2021 Hanging on "Sending Emails" Using Outlook 3
T Outlook Desk Top 2021 Overdoing Security Using Outlook 7

Similar threads