automate dates in outlook template

Status
Not open for further replies.

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

Forum Admin

Senior Member
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.
Thread starter Similar threads 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
2 automate login to outlook we app Exchange Server Administration 3
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
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
T Dates are not in bold from a shared calendar (Outlook 2010 ) Using Outlook 1
M Outlook does not bold calendar dates when events are scheduled for those dates. Using Outlook 1
T How to display dates from other calenders in task list Using Outlook 1
B Outlook tasks: due date changes after entering reminder or start dates Using Outlook 2
F Outlook message receive dates are wrong. How do I fix? Using Outlook 1
T Outlook Print drops dates Using Outlook 3
V Set-MailboxCalendarFolder -PublishDateRangeTo (How to set to ALL dates?) Exchange Server Administration 8
F Correct email dates corrupted during importing from Outlook Express Using Outlook 1
O How do I copy and paste calendar dates in 2010 outlook? Using Outlook 1
M Importing dates from Excel into Outlook Using Outlook 2
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 Copy/export dates/times from Inbox table view Outlook Wishlist 1
T comparing and subtracting sent and received dates Outlook VBA and Custom Forms 3
Similar threads


















































Top