Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumif to return a blank if sum range is blank | Excel Worksheet Functions | |||
Return Summed Count of Multiple Consecutive Numeric Values | Excel Worksheet Functions | |||
Adding a blank in Data Validation List? | Excel Discussion (Misc queries) | |||
Setting Purely BLANK Cell | Excel Worksheet Functions | |||
Blank Cells in Pivot Tables | Excel Discussion (Misc queries) |