#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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...
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,393
Default 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...



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sumif to return a blank if sum range is blank [email protected] Excel Worksheet Functions 3 May 25th 06 10:25 AM
Return Summed Count of Multiple Consecutive Numeric Values Sam via OfficeKB.com Excel Worksheet Functions 4 April 10th 06 10:35 PM
Adding a blank in Data Validation List? Pheasant Plucker® Excel Discussion (Misc queries) 10 March 20th 06 04:06 PM
Setting Purely BLANK Cell yokato95 Excel Worksheet Functions 4 August 18th 05 04:43 PM
Blank Cells in Pivot Tables Greg Excel Discussion (Misc queries) 1 March 16th 05 10:23 PM


All times are GMT +1. The time now is 01:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"