Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail merge dilemma!!
I am doing a mail merge in word 2003 but taking addresses from an excel
worksheet. When I get to choosing recepients the columns are all messed up. Basically instead of customer, address, zip it just recognizes address & zip. Whay is it not recognizing what I have in excel? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail merge dilemma!!
What are the field names of your Excel data? Exact spelling including
spaces required. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "kimcox_74" wrote in message ... I am doing a mail merge in word 2003 but taking addresses from an excel worksheet. When I get to choosing recepients the columns are all messed up. Basically instead of customer, address, zip it just recognizes address & zip. Whay is it not recognizing what I have in excel? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail merge dilemma!!
There are 5 columns.
Customer, Street address, City, State, Zip Also when I do preview the labels it only does one page of labels. Thanks! "Doug Robbins - Word MVP" wrote: What are the field names of your Excel data? Exact spelling including spaces required. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "kimcox_74" wrote in message ... I am doing a mail merge in word 2003 but taking addresses from an excel worksheet. When I get to choosing recepients the columns are all messed up. Basically instead of customer, address, zip it just recognizes address & zip. Whay is it not recognizing what I have in excel? |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail merge dilemma!!
The preview issue is normal. You have not completed the merge. You must
merge to the printer or to a new document. See http://www.gmayor.com/mail_merge_lab...#only_one_page As for the Excel data see http://www.gmayor.com/mail_merge_lab...th_word_xp.htm and avoid using the addressblock field. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org kimcox_74 wrote: There are 5 columns. Customer, Street address, City, State, Zip Also when I do preview the labels it only does one page of labels. Thanks! "Doug Robbins - Word MVP" wrote: What are the field names of your Excel data? Exact spelling including spaces required. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "kimcox_74" wrote in message ... I am doing a mail merge in word 2003 but taking addresses from an excel worksheet. When I get to choosing recepients the columns are all messed up. Basically instead of customer, address, zip it just recognizes address & zip. Whay is it not recognizing what I have in excel? |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail merge dilemma!!
Thank you all! i think I got it figured out now!~
"Graham Mayor" wrote: The preview issue is normal. You have not completed the merge. You must merge to the printer or to a new document. See http://www.gmayor.com/mail_merge_lab...#only_one_page As for the Excel data see http://www.gmayor.com/mail_merge_lab...th_word_xp.htm and avoid using the addressblock field. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org kimcox_74 wrote: There are 5 columns. Customer, Street address, City, State, Zip Also when I do preview the labels it only does one page of labels. Thanks! "Doug Robbins - Word MVP" wrote: What are the field names of your Excel data? Exact spelling including spaces required. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "kimcox_74" wrote in message ... I am doing a mail merge in word 2003 but taking addresses from an excel worksheet. When I get to choosing recepients the columns are all messed up. Basically instead of customer, address, zip it just recognizes address & zip. Whay is it not recognizing what I have in excel? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail-Merge: Can we have master detail relationship or multiple entities in word Mail-Merge? | Microsoft Word Help | |||
Take Mail Merge in Word back the the Mail Merge Helper 1,2,3 Form. | Mailmerge | |||
collate pages in mail merge vs mail merge being single document | Mailmerge | |||
Table Dilemma, Help! | Microsoft Word Help | |||
mail merge doc with further linked/embedded mail merge docs not playing the game | Mailmerge |