1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

Discussion in 'Windows XP' started by Tracy, Feb 1, 2010.

  1. Tracy

    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
     
  2. David H. Lipman

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

    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
     
  4. David B.

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

    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.
     
  6. Richard in AZ

    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.
     
  7. Pegasus [MVP]

    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.
     
  8. Gord Dibben

    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?
     
  9. Anita

    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.
     
  10. Richard in AZ

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

    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.
     
  12. alanglloyd@aol.com

    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
     

Share This Page