create outlook email template with fields

#Create outlook email template with fields how to#

Obj.Body = Replace(obj.Body, 'xxxxxxxxxx', Format(Now - 8, 'MMMM dd, yyyy')) The only problem with it is that it completely strips out any and all formatting, including tables, colors, etc. *edit #2: I've also come across a decent example of a quick find/replace for the body. I'd also like to know if I can tell it to insert that date into multiple places by doing something like a find/replace.

#Create outlook email template with fields how to#

If I stick with this approach, I just need to know how to set it up so that instead of today's date, it inserts the date from the prior week's Monday (I don't always run the report on the same day, so I can't just tell it to do something simple like subtract eight days from today's date). TypeName(Application.ActiveWindow) = 'Inspector' Then *edit #1: Of course, right after I post this, I find that one of the solutions I found to simply add text to where the cursor is now works. None of these approaches have worked for me. I was hoping to create something simple like how Word does: Selection.TypeText Text:='Hello!' I can write a macro that will open up a new message and populate various areas (subject line, body, etc.), but I can't get that macro to work on just a message that I already have open.įor all of the examples I've tried that actually run on the message that I already have open, I can only get it to add text to the body. (If I could somehow set up bookmarks in the template for where I want the date added, that would be even better.) I've done a lot of research on inserting text and I keep running into the same two problems with the examples I've been finding: I want to add a date to where I have the cursor. (Basically, it's a 'week of' date for the week I'm reporting, which is always the previous week.) I have a template for a report I send out every week and in four separate places (three in the body, one in the subject line) is a date that corresponds to the Monday of the prior week.