Monday, September 13, 2010

How do I ';split'; First & Last Names in MAIL MERGE when I want to address them by FIRST NAME? Tks in advance!

Hi Folks:



I am confused with the Mail Merge options in WORD under Tools/Letters and the Mailings/Mail Merge



Wizard ...



The '; Address Block'; (Step 4 of the WORD DOC ) does NOT make it clear how to use the Addressing



Options for both ';split'; names and combined City/State/Zip addressing.



I need to take the addressing data from my Excel Spreadsheet and use just the Dear ';John'; part from



a cell within the columns that has all the ';John Doe'; names within it.



Also, I need to do the opposite when using a City, State and Zip from 3 different Cells in columns



when I need to use all 3 entities in ONE address box combined.



eg



John Doe

123 Main Street,

Anytown, California, 92122



Dear John:







Thanks folks - I would really appreciate this help.

Tenacity