Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / December 2003

Tip: Looking for answers? Try searching our database.

Merging Data From Excel Into Word Labels

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jennifer - 05 Dec 2003 16:40 GMT
Hello,

I would like to merge data from an Excel spreadsheet into
MS Word labels.  I have taken the following steps in Word:

1)  Tools, MailMerge
2)  Create, Mailing Labels
3)  Select "Active Window"
4)  Select "Get Data"
5)  Select "Open Data Source" and open my file in Excel
6)  Click on "Entire Spreadsheet", OK
7)  Click on "Set up Main Document"
8)  Select the "Shipping 2 x 4" Labels, OK
9)  This is where I get stsuck ... I have the Create
Labels dialgoe box open, with the option to Insert Merge
Fields or Insert Postal Bar Code.  If I select "Insert
Merge Fields" my only options
are "AutoMergeField", "AutoMergeField1", "AutoMergeField2",
and "AutoMergeField3".  Shouldn't I have the option to
insert "FirstName", "LastName", "Address1", "City", etc.  
These are the headings that are in my Excel spreadsheet.  

Please help!!

Thank you,
Jennifer
Graham Mayor - 05 Dec 2003 17:32 GMT
The following article on the subject should help
http://www.gmayor.dsl.pipex.com/mail_merge_labels_with_word_xp.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
    Graham Mayor -  Word MVP
      E-mail gmayor@mvps.org
  Web site www.gmayor.dsl.pipex.com
 Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> Hello,
>
[quoted text clipped - 22 lines]
> Thank you,
> Jennifer
- 06 Dec 2003 02:33 GMT
Thank you, Graham.  I don't have the options that are
described in the document ... maybe because I have Office
2000 Professional Version installed on my computer.  Do
you have a document that would pertain to 2000
Professional?

>-----Original Message-----
>The following article on the subject should help
[quoted text clipped - 17 lines]
>> Fields or Insert Postal Bar Code.  If I select "Insert
>> Merge Fields" my only options

are "AutoMergeField", "AutoMergeField1", "AutoMergeField2",
>> and "AutoMergeField3".  Shouldn't I have the option to
>> insert "FirstName", "LastName", "Address1", "City", etc.
[quoted text clipped - 6 lines]
>
>.
Graham Mayor - 06 Dec 2003 11:19 GMT
I regret I have not prepared a similar document for earlier Word versions.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
    Graham Mayor -  Word MVP
      E-mail gmayor@mvps.org
  Web site www.gmayor.dsl.pipex.com
 Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> Thank you, Graham.  I don't have the options that are
> described in the document ... maybe because I have Office
[quoted text clipped - 43 lines]
>>
>> .
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.