Exporting mailing list to MS Word using Mail Merge

  • Thread starter Thread starter Carlos
  • Start date Start date
C

Carlos

I am having trouble using the Mail Merge fuction on MS
Word 2003. I cannot import list from saved .xls file in
Excell 2003. I have full customer information fileds
including name, address, and city/state fields but cannot
import these fields to Word to create mailing labels.Need
help!

Thank You
 
Each entry in the excel file needs to be on one row.
Example:

A2 = lastname1, B2 = firstname1, C2 = Address1, D2 =
state1 ...

A3 = lastname 2, B3 = firstname2 etc etc


Make sure there is no other information on that sheet
(except possibly column headers)

Then in Word, using the mail merge, you select the
masterfile where the info is to be inserted. It will ask
you to associate a sourcefile (the excel list). Then you
edit the target (Word file) and insert the field codes.
Save that file and perform the merge. Look at the toolbars
for a button that will let you view the merged records
instead of the master document.

Hope that helps a little.
 
Back
Top