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

  • Thread starter Thread starter Tracy
  • Start date Start date
T

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?
 
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.
 
In
Tracy said:
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?
Click to expand...

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.
 
Anita said:
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.
Click to expand...
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.
 
Richard in AZ said:
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.
Click to expand...

.. . . which is why it's best for the OP to post her question in a Word
newsgroup where the Word experts dwell.
 
In
Richard in AZ said:
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.
Click to expand...

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.
 
Anita said:
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.
Click to expand...

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.
 
....
Are you working with OpenOffice Writer 3.0?
Click to expand...


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.
Click to expand...

<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.
 
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?
Click to expand...

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
 
Back
Top