Difficulty providing correct info for Data merge to WORD

  • Thread starter Thread starter blazer1
  • Start date Start date
B

blazer1

I am using Excel as a database for Labels to be created in WORD. My
Excel Doc is populated as follows:
Column A1-30:Name
B1-30: Address
C1-30: City
D1-30:State
E1-30: Zip
I used http://word.mvps.org/FAQs/MailMerge/CreateAMailMergeContent.htm
as a guide to create the labels. I followed the guide and used the
Data Merge Manager in WORD. I selected the Label in the Create option,
which produced a blank Word Doc with Label Examples. I selected the
Open Data Source in the Get Data Option, which produced a Open
worksheet window. Clicking OK produced an Edit Window with two
buttons and a sample label box. Populating the Sample Label box with
any info and clicking OK will populate each label with the same info.
I am unable to get a WORD document with labels with info from the
Excel worksheet.

Am I missing something? Any assistance would be greatly appreciated
 
I am using Excel as a database for Labels to be created in WORD.  My
Excel Doc is populated as follows:
Column A1-30:Name
B1-30: Address
C1-30: City
D1-30:State
E1-30: Zip
I usedhttp://word.mvps.org/FAQs/MailMerge/CreateAMailMergeContent.htm
as a guide to create the  labels.  I followed the guide and used the
Data Merge Manager in WORD. I selected the Label in the Create option,
which produced a blank Word Doc with Label Examples.  I selected the
Open Data Source in the Get Data Option, which produced a Open
worksheet window.  Clicking OK produced an Edit Window with two
buttons and a sample label box.  Populating the Sample Label  box with
any info and clicking OK will populate each label with the same info.
I am unable to get a WORD document with labels with info from the
Excel worksheet.

Am I missing something?  Any assistance would be greatly appreciated
Click to expand...


It sounds like you havent merged the document yet.

Look for 'Merge To' on the toolbar.

Regards

David
 
Back
Top