automate text in e-mail 1

[OCM]

Greetings,

Using Outlook 2010 I created a template that goes out to certain recipients every day. I’m trying to automate this process (subject line & body) my requirement is as follows:

1. e-mail goes out Tuesday - Friday will have
Subject: report for: <today’s date> in “mm/dd/yy” format

Body of e-mail
I ran for: <yesterday’s date> “mm/dd/yy”
then I ran for: <today’s date> “mm/dd/yy”

2. e-mail goes out on Monday will have
Subject: report for: <today’s date> in “mm/dd/yy” format

Body of e-mail
I ran for: <Friday’s date> “mm/dd/yy”
then I ran for: <Saturday’s date> “mm/dd/yy”

TIA,
Regards


OCM

 

[Andrzejek]

Show us your code that you already have.
it will be some simple modifications to your code.

Have fun.

---- Andy

 

[OCM]

Andy, actually, I don’t have any code for this. That’s why I posted on this forum to see the best way to accomplish the above.
What I’ve done is just created outlook template w/ recipients e-mail and text that goes on the body of the e-mail. Every day, I’ll open this template so I do not have to type the text again (I just change the dates I mentioned in my original post). So, my question was, is there a way, when I open my template, the dates are updated automatically?


OCM

 

[Andrzejek]

I am sure there is a way.
What I would do is - start a Macro recorder in Outlook and do by-hand some steps, like type the Subject line and some text in the Body of the message. Then in VBA editor see the code of the macro. This way you will know what you need to do to change the Subject and body to what you need.

Have fun.

---- Andy

 

[Andrzejek]

Oops, turns out you cannot record a Macro in Outlook :-( , but you can Create an Email Macro with Its Own Button The rest is just VBA

Have fun.

---- Andy

 

[OCM]

Andy, thank you for your replies and the useful link you provided.

Regards,



OCM

 

[Andrzejek]

You are welcome

And once you get going with VBA in Outlook, start another thread in VBA Visual Basic for Applications (Microsoft) Forum. There are peolpe who can help you with VBA questions.


Have fun.

---- Andy