• Welcome to Tux Reports: Where Penguins Fly. We hope you find the topics varied, interesting, and worthy of your time. Please become a member and join in the discussions.

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

T

Tracy

Flightless Bird
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
 
D

David H. Lipman

Flightless Bird
From: "Tracy" <Tracy@discussions.microsoft.com>

| 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.

--
Dave
http://www.claymania.com/removal-trojan-adware.html
Multi-AV - http://www.pctipp.ch/downloads/dl/35905.asp
 
L

Lem

Flightless Bird
Tracy wrote:
> 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

--
Lem

Apollo 11 - 40 years ago:
http://www.nasa.gov/mission_pages/apollo/40th/index.html
 
D

David B.

Flightless Bird
First idea would be to repost to an Excel group, this group discusses
Windows XP.

--


--
"Tracy" <Tracy@discussions.microsoft.com> wrote in message
news:94F519B8-BAB6-408F-A480-DC3B5C51DF43@microsoft.com...
> 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
 
A

Anita

Flightless Bird
In news:94F519B8-BAB6-408F-A480-DC3B5C51DF43@microsoft.com,
Tracy <Tracy@discussions.microsoft.com> typed:

> 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.
 
R

Richard in AZ

Flightless Bird
"Anita" <anita@privacy.met> wrote in message news:7sokvlFirgU1@mid.individual.net...
> In news:94F519B8-BAB6-408F-A480-DC3B5C51DF43@microsoft.com,
> Tracy <Tracy@discussions.microsoft.com> typed:
>
>> 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.
>

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.
 
P

Pegasus [MVP]

Flightless Bird
"Richard in AZ" <me@mailinator.com> said this in news item
news:-OQq2pa3oKHA.3792@TK2MSFTNGP06.phx.gbl...
>
> "Anita" <anita@privacy.met> wrote in message
> news:7sokvlFirgU1@mid.individual.net...
>> In news:94F519B8-BAB6-408F-A480-DC3B5C51DF43@microsoft.com,
>> Tracy <Tracy@discussions.microsoft.com> typed:
>>
>>> 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.
>>

> 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.
 
G

Gord Dibben

Flightless Bird
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


On Mon, 1 Feb 2010 09:31:01 -0800, Tracy <Tracy@discussions.microsoft.com>
wrote:

>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?
 
A

Anita

Flightless Bird
In news:-OQq2pa3oKHA.3792@TK2MSFTNGP06.phx.gbl,
Richard in AZ <me@mailinator.com> typed:

>> 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.


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.
 
R

Richard in AZ

Flightless Bird
"Anita" <anita@privacy.met> wrote in message news:7sp07nFoacU1@mid.individual.net...
> In news:-OQq2pa3oKHA.3792@TK2MSFTNGP06.phx.gbl,
> Richard in AZ <me@mailinator.com> typed:
>
>>> 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.

>
> 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.
 
A

Anita

Flightless Bird
"Richard in AZ" <me@mailinator.com> wrote in message
news:-OHSNJ$6oKHA.3948@TK2MSFTNGP06.phx.gbl...

>>>> 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.

....
> 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.
 
A

alanglloyd@aol.com

Flightless Bird
On Feb 1, 5:31�pm, Tracy <Tr...@discussions.microsoft.com> wrote:
> 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
 
Top