Difficulty providing correct info for Data merge to WORD

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
 
D

David Heaton

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


It sounds like you havent merged the document yet.

Look for 'Merge To' on the toolbar.

Regards

David
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top