automate dates in outlook template

Status
Not open for further replies.
O

oceancity

Member
Greetings,

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?

TIA
 

Attachments

  • Sample template.doc
    30 KB · Views: 611
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.
 
Status
Not open for further replies.
< Outllok 2013 - Automatically deleted emails | Apply Follow up flag ONLY to the people cc'd. >
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
e_a_g_l_e_p_i Question about Outlook 2021 and Gmail Using Outlook 8
J Outlook VBA to send from Non-default Account & Data Files Outlook VBA and Custom Forms 2
P Limited Support for 3rd Party Mail in new Outlook? Using Outlook 1
O Any 3rd party tool that sync (mirror) from Outlook Calendar to Google Calendar? Using Outlook 5
T Outlook is categorizing emails incorrectly Using Outlook 1
R Legacy Outlook on Mac Email Cache Using Outlook 0
A Outlook can't remember outlook.com, Exchange password. Using Outlook 3
S Related messages show in main Outlook window vice new Advanced Find windows Using Outlook 1

Similar threads

Back
Top