Results 1 to 12 of 12
  1. #1
    Star Lounger
    Join Date
    Sep 2003
    Location
    Toronto, Ontario, Canada
    Posts
    52
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Macro to Mass Mail (Outlook 2000)

    I have assigned a number of contacts to a category and created an email message saved in the Drafts folder.
    I want to send the email to each of the contacts in the category such that only the contact's name appears in the TO box.
    This I don't believe is possible with a distribution list, so I have tried to write a macro using code from Barry Simon's "Maximizing Outlook 2000" book.
    Can anyone look at my code and tell me what's wrong. It's probably something really obvious.
    Thanks

  2. #2
    Super Moderator
    Join Date
    Dec 2000
    Location
    Renton, Washington, USA
    Posts
    12,560
    Thanks
    0
    Thanked 4 Times in 4 Posts

    Re: Macro to Mass Mail (Outlook 2000)

    Enter the distribution list in the "Bcc" address field.

    Now running HP Pavilion a6528p, with Win7 64 Bit OS.

  3. #3
    Star Lounger
    Join Date
    Sep 2003
    Location
    Toronto, Ontario, Canada
    Posts
    52
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macro to Mass Mail (Outlook 2000)

    But putting the distribution list in the bcc field does not put the individual names in the To field. I want the email to look personalized.

  4. #4
    Platinum Lounger
    Join Date
    Jan 2001
    Location
    Roanoke area, Virginia, USA
    Posts
    3,729
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macro to Mass Mail (Outlook 2000)

    Use mail merge. Group by the category in contacts, then Tools, Mail merge. you'll need ot copy the body of the message in drafts into the mail merge document since oyu can't merge to it directly. If you have the SP installed that blocks attachments, use HTML formatting to avoid the warning prompts or use an app called ClickYes that clicks the prompts for you.

  5. #5
    Star Lounger
    Join Date
    Sep 2003
    Location
    Toronto, Ontario, Canada
    Posts
    52
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macro to Mass Mail (Outlook 2000)

    Yes, mail merge will produce the message as an attachment, but I'm sending to people who will often not open an attachment. I would really like individual e-mails. Is there a reason you are avoiding code?
    Ross

  6. #6
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Macro to Mass Mail (Outlook 2000)

    Can you indicate what is going wrong with the macro, please? Error message? Security prompt? Are zero messages generated? Only one? Name in the wrong place?

  7. #7
    Platinum Lounger
    Join Date
    Jan 2001
    Location
    Roanoke area, Virginia, USA
    Posts
    3,729
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macro to Mass Mail (Outlook 2000)

    It shouldn' send as an attachment, but as the message body. Choose form letters, merge to email - choose HTML or plain text as the format, not attachment.

    Are you using word or outlook as the email editor?

    <hr>Is there a reason you are avoiding code?<hr>

    Why use code when Outlook has the feature built in? Or look for 3rd party addins at http://www.slipstick.com - if none exist that do what you need, then it's time for you to work on writing your code. At $50/hour, I prefer to use the existing solutions because they are the most cost effective for me.

  8. #8
    Star Lounger
    Join Date
    Sep 2003
    Location
    Toronto, Ontario, Canada
    Posts
    52
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macro to Mass Mail (Outlook 2000)

    MaryJ,
    Thank you. It had completely slipped my mind that the message body can be produced in Word.
    But I will take a look at the SlipStick site.
    Thanks again.
    Ross <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>

  9. #9
    Super Moderator
    Join Date
    Dec 2000
    Location
    Renton, Washington, USA
    Posts
    12,560
    Thanks
    0
    Thanked 4 Times in 4 Posts

    Re: Macro to Mass Mail (Outlook 2000)

    You stated "But putting the distribution list in the bcc field does not put the individual names in the To field".
    You are correct only while you are viewing as a sender. But, when the receiver reads their mail, it will be addressed to them and only to them. That is what the Bcc is all about. The"salutation" is NOT used by any of the "To, CC or Bcc" fields of the email program. As stated above by others you are going to need to use a "mail merge".

    Send a message to yourself using ONLY the Bcc field and see what I mean. If you have more than one email address try all of them with one send, and see again what I mean.

    Now running HP Pavilion a6528p, with Win7 64 Bit OS.

  10. #10
    Star Lounger
    Join Date
    Sep 2003
    Location
    Toronto, Ontario, Canada
    Posts
    52
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macro to Mass Mail (Outlook 2000)

    Dave,
    Point well-taken about the Bcc names.
    The merge route, however is problematic because the Categories field is not one of the fields available. So I'm selecting the contacts in the appropriate category and exporting them to Excel. (Filtering in Excel would be another option).
    Thanks again for your help.
    Ross

  11. #11
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Macro to Mass Mail (Outlook 2000)

    How about creating a temporary new Contacts folder, filtering your existing Contacts by categories, select all in the appropriate Category, select Edit, Copy to Folder, into the temporary Contacts folder, and mail-merging from there. (I don't routinely use categories, there may be a better way of doing this. However, I often create partial duplicates of my Contacts folder for code testing purposes, it can be done very quickly.)
    -John ... I float in liquid gardens
    UTC -7ąDS

  12. #12
    Star Lounger
    Join Date
    Sep 2003
    Location
    Toronto, Ontario, Canada
    Posts
    52
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macro to Mass Mail (Outlook 2000)

    John,
    Good idea. This will be done by another user and I was tring to make the whole thing easy and transparent. I thought if I created the extra Contacts folder the user would be inclined to try to keep both folders up-to-date. You can also avoid this by choosing only to merge the selected items which of course could be restricted to those displayed in a particular category.
    Ross

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •