ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Drawing a Blank (https://www.excelbanter.com/excel-discussion-misc-queries/114652-drawing-blank.html)

Beacher67

Drawing a Blank
 
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 although the hotmail address may be
used...

Bernard Liengme

Drawing a Blank
 
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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Beacher67" wrote in message
...
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 although the hotmail address may be
used...




Gord Dibben

Drawing a Blank
 
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/MailMe...AMailMerge.htm

http://www.mvps.org/word/FAQs/MailMe...DataSource.htm


Gord Dibben MS Excel MVP

On Mon, 16 Oct 2006 12:09:02 -0700, Beacher67
wrote:

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 although the hotmail address may be
used...


Gord Dibben MS Excel MVP


All times are GMT +1. The time now is 08:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com