Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Changing recipient name in a letter draft in MS word from a list in MS Excel

  1. #1
    New Member
    Join Date
    Jun 2017
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Changing recipient name in a letter draft in MS word from a list in MS Excel

    Dear Excel Helpers,

    I need a help in excel macro. I have a word with draft of letter, and an excel sheet with list of recipients. I want to create a macro in which following actions happen
    1. change the recipients name in the letter in MS Word from the list of names in excel
    2. save the word document document with recipient name.

    Thank you.

    Letter Draft in Word;

    To
    XYZ - This name to be replaced with every macro click


    List of names in excel -
    1. wew
    2. wgr
    3.oek
    4. wmjk

  2. #2
    Moderator Macropod's Avatar
    Join Date
    Aug 2007
    Location
    Canberra, Australia
    Posts
    3,230
    Post Thanks / Like
    Mentioned
    6 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Changing recipient name in a letter draft in MS word from a list in MS Excel

    See Run a Mailmerge from Excel, Sending the Output to Individual Files in the Mailmerge Tips and Tricks thread at:
    http://www.msofficeforums.com/mail-m...ps-tricks.html
    Last edited by Macropod; May 16th, 2019 at 06:43 PM.
    Cheers
    Paul Edstein
    [MS MVP - Word]

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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