Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge from Excel
I have tried to follow the help file to merge a list of names from Excel into
Labels in Word. When I get to the step that allows me to preview the merge it is always blank. Also when I print the labels they are blank. Help! |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge from Excel
You have to insert some mailmerge fields from your Excel workbook into the
label document - Word does not do this automatically (it cannot know which data you want to insert). See for example Graham Mayor's pages at http://www.gmayor.com/mail_merge_lab...th_word_xp.htm or http://www.gmayor.com/merge_labels_with_word_2007.htm Peter Jamieson "bmorganh" wrote in message ... I have tried to follow the help file to merge a list of names from Excel into Labels in Word. When I get to the step that allows me to preview the merge it is always blank. Also when I print the labels they are blank. Help! |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge from Excel
In message
at 08:25:10 on Thu, 1 Nov 2007, Peter Jamieson wrote You have to insert some mailmerge fields from your Excel workbook into the label document - Word does not do this automatically (it cannot know which data you want to insert). See for example Graham Mayor's pages at http://www.gmayor.com/mail_merge_lab...th_word_xp.htm or http://www.gmayor.com/merge_labels_with_word_2007.htm For the life of me I could not find the "Insert Merge Fields" button when going from 2000 (where the button was labelled with those words) to 2003, but I have it now. The Office 2003 page is slightly different as it's more wizard like, but the above made me think a bit more to look for the button, so thanks for your post. -- Mike News |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge from Excel
In Word 2002/2003 it's often easier to enable the MailMerge toolbar (e.g. in
View|Toolbars) than to use the wizard. It doesn't appear/disappear automatically like the one in Word 2000 and earlier though... Peter Jamieson "Mike" S wrote in message ... In message at 08:25:10 on Thu, 1 Nov 2007, Peter Jamieson wrote You have to insert some mailmerge fields from your Excel workbook into the label document - Word does not do this automatically (it cannot know which data you want to insert). See for example Graham Mayor's pages at http://www.gmayor.com/mail_merge_lab...th_word_xp.htm or http://www.gmayor.com/merge_labels_with_word_2007.htm For the life of me I could not find the "Insert Merge Fields" button when going from 2000 (where the button was labelled with those words) to 2003, but I have it now. The Office 2003 page is slightly different as it's more wizard like, but the above made me think a bit more to look for the button, so thanks for your post. -- Mike News |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge from Excel
In message
at 23:51:26 on Sat, 3 Nov 2007, Peter Jamieson wrote In Word 2002/2003 it's often easier to enable the MailMerge toolbar (e.g. in View|Toolbars) than to use the wizard. It doesn't appear/disappear automatically like the one in Word 2000 and earlier though... I had done that, but spotting the icon which used to be a text label had me foxed for ages. -- Mike News |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to merge Excel chart for mass Word Mail Merge for employees | Mailmerge | |||
ExcelWord Mail merge transfers 16 digits when Excel shows only 3 | Mailmerge | |||
mail merge from excel-date in excel January 1, 2005 -merged dbase. | Mailmerge | |||
How to convert a mail merge document back to excel after mail mer | Microsoft Word Help | |||
Insert Merge Field problem with Word-Mail Merge from Excel documen | Microsoft Word Help |