Mailing List/Letter Merge in Mac Office '04

Discussion in 'Mac Apps and Mac App Store' started by TheJayWay, Apr 29, 2007.

  1. TheJayWay macrumors member

    Joined:
    Apr 18, 2007
    Location:
    Winnipeg, Manitoba, Canada
    #1
    Hey Guys and Gals,

    I'm trying to figure out how to take data from a excel spreadsheet and plug it into a letter so that the address changes to match that of the recipient as well as the Dear XXX space.

    Anybody ever done this? I'm flummoxed and have not a clue.

    Any help would be great!

    Thanks! :confused:
     
  2. iSaint macrumors 603

    iSaint

    Joined:
    May 26, 2004
    Location:
    South Mississippi y'all, near the water!
    #2
    Tools > Data Merge Manager

    One of my favorite features.

    Make sure you have the data on the spreadsheet broken up into the fields you wish to enter. i.e. Name; Address; City; State; Zip, etc.

    Once you start the Merge tool, a Merge Pallete will appear, just as the formatting pallete does on the right of the screen. You will need to select the file name that is the spreadsheet for the source data. You can then drag and drop field names into the Word document. It's really much easier on a Mac than a PC.

    Use your Help function if I'm not clear, or if you get lost. :)
     

Share This Page