Drawing a Blank

B

Beacher67

I am not a regular Excel 2003 user nor am I a regular WORD user. However, I
have merged a list from Excel to label format in Word previously but now
cannot figure out what I'm doing wrong. I have looked and looked at the HELP
items and they are of no help.

I guess my first question is... Do I not have to title/label/name or
whatever the two columns that I have completed in Excel? If so, please tell
me how to do so. I only have columns A & B and want to simply name them
Number and Name.

Secondly, do I not have to also indicate these labels/titles/names,
whatever, at the WORD document? If so, once again please tell me how.

Thanks... my email is [email protected] although the hotmail address may be
used...
 
B

Bernard Liengme

Q1
Right click the row header 1
Use Insert to make a new row 1
Type Name in A1 and Number in B1
Save the file
Now use Word Merge

Q2
Yes, but it depends how you do the mail merge
In dialogs look for the button "Match Keys"
Question best asked on a Word newsgroup (what a cop-out!)

best wishes
 
G

Gord Dibben

For help on Word mail merge using Excel or Access as the data source.

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

http://www.mvps.org/word/FAQs/MailMerge/CreateAMailMerge.htm

http://www.mvps.org/word/FAQs/MailMerge/CreateADataSource.htm


Gord Dibben MS Excel MVP

I am not a regular Excel 2003 user nor am I a regular WORD user. However, I
have merged a list from Excel to label format in Word previously but now
cannot figure out what I'm doing wrong. I have looked and looked at the HELP
items and they are of no help.

I guess my first question is... Do I not have to title/label/name or
whatever the two columns that I have completed in Excel? If so, please tell
me how to do so. I only have columns A & B and want to simply name them
Number and Name.

Secondly, do I not have to also indicate these labels/titles/names,
whatever, at the WORD document? If so, once again please tell me how.

Thanks... my email is [email protected] although the hotmail address may be
used...
Click to expand...

Gord Dibben MS Excel MVP
 
Top