I have a letter that I have to send out, and need help merging all the names and addresses

3 replies
Hi how are you,

I have a physical letter I have to send out, and I've seen someone make a list of all the names in Microsoft Word, and then it automatically substitutes the names and their home addresses and makes a letter for each one. How do I do this? Is there a guide to how to do this? I'm guessing this is extremely common in the email marketing world and I sound like a complete noob but I've never done this before.

Thanks
#addresses #letter #merging #names #send
  • Profile picture of the author MightyWarrior
    Hi, it's called mail merge -- google is your friend
    as is the application's F1 Help manual.
    {{ DiscussionBoard.errors[9875420].message }}
    • Profile picture of the author timrodriguez
      So I got the mail merge to work, the only problem is the excel spreadsheet has the name of the people in one cell and is ordered last name, first name. But both are in ONE cell. This is a problem because I need it to read, Dear Joe Smith... Not Dear Smith, Joe. Is there any way of fixing this?
      {{ DiscussionBoard.errors[9875507].message }}
      • Use this formula
        =MID(A2,SEARCH(",",A2)+2,LEN(A2)-SEARCH(",",A2)+2)&" "&LEFT(A2,SEARCH(",",A2)-1)

        Paste it to the same line where first entry is, just into another column.
        If first "Last name, First name" entry is not in A2, then change cell address in this formula.
        Then just take corner of the cell with this formula and drag it to the last cell.
        I hope you got what I mean
        {{ DiscussionBoard.errors[9876860].message }}

Trending Topics