Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

There was a question on adding a macro in Outlook 2010 but the answer was a little unclear to me. I want a specific line of text to appear in an email that is sent to a specific group of people (example: agenda editors). It is "These are the current changes for July 23, 2012 (date automatically updates)." Where do I configure this or put the text for this?

share|improve this question

Try this

Sub Boilerplate_Agenda_Editors()

    Dim objMail As MailItem
    Dim allRecipients As Recipients

    Set objMail = Application.CreateItem(olMailItem)
    Set allRecipients = objMail.Recipients

    allRecipients.Add "Your distribution list name inside the quotes"

    objMail.Subject = "Attention Agenda Editors"
    objMail.Body = "These are the current changes for " & Format(Now, "mmmm dd, yyyy") & "."

    SendKeys "^{END}"


    Set objMail = Nothing
    Set allRecipients = Nothing

End Sub

Editor and button help -

Macro security should be set to medium.

Button help -

share|improve this answer
you can put this code into Application_ItemSend event instead if you want complete automation – tumchaaditya Aug 2 '12 at 6:55
@tumchaaditya - Only if you want every email you send to say the same thing, except for the date. :) – niton Aug 2 '12 at 10:32
you could check whom the mail is being sent to in the macro.. – tumchaaditya Aug 3 '12 at 3:51

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .