Making labels from Merge Mail in Word (2007) from Excel list

[Tracy]

When attempting to make labels by using Merge mail in Word (followed all
instructions in Excell on formating the list of recipietnts and then
following Word instructions to download the recipients from Excel onto the
labels, I continue to get "Unrecognized format from Excel".
Anyone have any ideas?

 

[David H. Lipman]

From: "Tracy" <[email protected]>

| When attempting to make labels by using Merge mail in Word (followed all
| instructions in Excell on formating the list of recipietnts and then
| following Word instructions to download the recipients from Excel onto the
| labels, I continue to get "Unrecognized format from Excel".
| Anyone have any ideas?
| --
| Tracy

Please ask in a MS Office news group as the question asked is specific to MS Office suite
and not specific to Windows XP.

 

[Lem]

When attempting to make labels by using Merge mail in Word (followed all
instructions in Excell on formating the list of recipietnts and then
following Word instructions to download the recipients from Excel onto the
labels, I continue to get "Unrecognized format from Excel".
Anyone have any ideas?

Word Mailmerge and Fax Newsgroup:
microsoft.public.word.mailmerge.fields
http://www.microsoft.com/office/com...ft.public.word.mailmerge.fields&lang=en&cr=US

 

[Anita]

In

When attempting to make labels by using Merge mail in Word (followed
all instructions in Excell on formating the list of recipietnts and
then following Word instructions to download the recipients from
Excel onto the labels, I continue to get "Unrecognized format from
Excel".
Anyone have any ideas?

The "Mail Merge Wizard" in http://openoffice.org is *so* simple (Tools ->
Mail Merge Wizard -> Create -> Insert Address Block -> Select Address
List -> Add -> <select *.xls file>) that one wonders why you'd ever want to
use Word.

 

[Richard in AZ]

In

The "Mail Merge Wizard" in http://openoffice.org is *so* simple (Tools ->
Mail Merge Wizard -> Create -> Insert Address Block -> Select Address
List -> Add -> <select *.xls file>) that one wonders why you'd ever want to
use Word.

You might want to review your help a bit further. The steps you give does not produce labels and
the instructions for labels does not allow Excel files to be used.

 

[Pegasus [MVP]]

You might want to review your help a bit further. The steps you give does
not produce labels and the instructions for labels does not allow Excel
files to be used.

.. . . which is why it's best for the OP to post her question in a Word
newsgroup where the Word experts dwell.

 

[Gord Dibben]

Assuming you are using Word for the mailmerge and Excel for the source see
these sites for help.

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

http://www.mvps.org/word/FAQs/MailMerge/CreateAMailMerge.htm

http://www.mvps.org/word/FAQs/MailMerge/CreateADataSource.htm


Gord Dibben MS Excel MVP

 

[Anita]

In

You might want to review your help a bit further. The steps you give
does not produce labels and the instructions for labels does not
allow Excel files to be used.

One assumes sufficient intelligence on the part of the OP to choose whatever
page layout is desired, and the mail merge wizard most ceratinly *does*
allow excel files.

 

[Richard in AZ]

In

One assumes sufficient intelligence on the part of the OP to choose whatever
page layout is desired, and the mail merge wizard most ceratinly *does*
allow excel files.

Are you working with OpenOffice Writer 3.0?
I have taught Word for 8 years and I cannot figure out how to access an Excel file in the OOo mail
merge.
It only will open OOo databases.

 

[Anita]

....
Are you working with OpenOffice Writer 3.0?

We *always* keep our software up-to-date, and are using OO Writer 3.1.0
(Help -> Check for Updates).

I have taught Word for 8 years and I cannot figure out how to access an Excel file in the OOo mail
merge.
It only will open OOo databases.

<sigh> I had thought the "Mail Merge Wizard" keystroke sequence above was
easy enough to follow. Of course your xls spreadsheet requires column
headings to match what's in the Address Block fields, e.g. "Title", "First
Name" etc. (whatever you've defined) but those are topics for the OO users'
forums, and you are advised to take your questions there. I simply addressed
the OP's problem succinctly with no intention of starting an off-topic
discussion.

My apologies to the Usenet newsgroup.

 

[alanglloyd]

When attempting to make labels by using Merge mail in Word (followed all
instructions in Excell on formating the list of recipietnts and then
following Word instructions to download the recipients from Excel onto the
labels, I continue to get "Unrecognized format from Excel".
Anyone have any ideas?

To make labels from a data store I always use Tools > Envelopes &
Labels, not Tools > Mail Merge. Or are they _enormous_ labels & so
need treating as a letter.

Excel works fine for me for a data source for both Mail Merge and
Envelopes & Labels.

Alan Lloyd