Results 1 to 10 of 10

Thread: Word Macro

  1. #1
    New Lounger
    Join Date
    Sep 2015
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Word Macro

    Is there a macro for word that will merge the current document with Excel fields, put the word document in outlook and send to email columns? I am not sure if i said it right.

    Use active word to merge with excel and send out email in column P...The word document will not be an attachment but in the email.
    Last edited by billisnice; 2015-10-12 at 11:20.

  2. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts
    Why do you need a macro? Word's mailmerge utilities will already do as you've described.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  3. #3
    New Lounger
    Join Date
    Sep 2015
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have 36 different email merges to do a day...I am using step by step. Is their a shorter way of doing to save me keystrokes.

  4. #4
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts
    Well, if you've set the document up as an email mailmerge main document and connected it to the Excel data source, all you need do is click on Finish & Merge>Send email messages, fill in the appropriate details, then OK to send all 36.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  5. #5
    New Lounger
    Join Date
    Sep 2015
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Each email merge goes with a different doc. Is there video of how to set up to make easy?

  6. #6
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts
    Quote Originally Posted by billisnice View Post
    Each email merge goes with a different doc.
    But your original post said:
    The word document will not be an attachment but in the email.
    Either there is an attachment or there isn't. For email mailmerges with attachments, see: http://word.mvps.org/FAQs/MailMerge/...ttachments.htm
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  7. #7
    New Lounger
    Join Date
    Sep 2015
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts
    My mail merge document is the writing in the outlook email. Nothing attached. Thanks

  8. #8
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts
    In that case, you don't need a macro. Whatever differences there are in the messages can be handled by field coding.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  9. #9
    New Lounger
    Join Date
    Sep 2015
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts
    What is field coding?

  10. #10
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts
    See, for example, the Mailmerge Tips and Tricks Sitcky thread in the Word forum:
    http://windowssecrets.com/forums/sho...ips-amp-Tricks

    Field coding can be use to conditionally output as little as a character, or even multiple pages with tables and diagrams, all with a single IF field, for example.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

Posting Permissions

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