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

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

Tracy

Guest
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
 
From: "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?

| --

| 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
 
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
 
First idea would be to repost to an Excel group, this group discusses

Windows XP.



--





--

"Tracy" 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
 
In news:94F519B8-BAB6-408F-A480-DC3B5C51DF43@microsoft.com,

Tracy 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 -> ) that one wonders why you'd ever want to

use Word.
 
"Anita" wrote in message news:7sokvlFirgU1@mid.individual.net...

> In news:94F519B8-BAB6-408F-A480-DC3B5C51DF43@microsoft.com,

> Tracy 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 -> ) 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.
 
"Richard in AZ" said this in news item

news:OQq2pa3oKHA.3792@TK2MSFTNGP06.phx.gbl...

>

> "Anita" wrote in message

> news:7sokvlFirgU1@mid.individual.net...

>> In news:94F519B8-BAB6-408F-A480-DC3B5C51DF43@microsoft.com,

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

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?
 
In news:OQq2pa3oKHA.3792@TK2MSFTNGP06.phx.gbl,

Richard in AZ typed:



>> The "Mail Merge Wizard" in http://openoffice.org is *so* simple

>> (Tools -> Mail Merge Wizard -> Create -> Insert Address Block ->

>> Select Address

>> List -> Add -> ) 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.
 
"Anita" wrote in message news:7sp07nFoacU1@mid.individual.net...

> In news:OQq2pa3oKHA.3792@TK2MSFTNGP06.phx.gbl,

> Richard in AZ typed:

>

>>> The "Mail Merge Wizard" in http://openoffice.org is *so* simple

>>> (Tools -> Mail Merge Wizard -> Create -> Insert Address Block ->

>>> Select Address

>>> List -> Add -> ) 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.
 
"Richard in AZ" 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 -> ) 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.



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.
 
On Feb 1, 5:31�pm, 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?



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
 
You must log in or register to reply here.
Back
Top