Results 1 to 4 of 4

Thread: Mail Merge error
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    May 2006
    Location
    New Jersey
    Posts
    375
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Mail Merge error

    Hi All
    First time trying to do this:
    I am trying to print labels from my Excel spreadsheet with Word using mail merge. It's a XLSM that I changed to XLSX. When Word tries to open the file, I get this message: This workbook contains unreadable content and cannot be opened.

    Any ideas?

    Thank you!
    Words alone cannot explain how grateful that I am to all the people here
    that take the time to help others and myself!
    Grateful member since 2006.

  2. #2
    Moderator mole999's Avatar
    Join Date
    Oct 2004
    Location
    UK
    Posts
    9,680
    Post Thanks / Like
    Mentioned
    15 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Mail Merge error

    changed or saved as, just changing the extension won't wash, you have to open in the original format and then save as
    • Yes I know there are better ways to do it. I just wish I knew them. - 97, 2003, 2007, 2010, 2013, 2016 & 2019
    • I wear my ignorance openly, excel is not my chosen career, its a means to an ends
    • Posting Guidelines Want to post well laid out questions and answers Translate Excel Versions
      Code:
      [CODE ]Put Your Code[/ CODE]
    • Settings > General Settings (on the left) scroll to the bottom, > Miscellaneous Options > Use ENHANCED
    • X-Posting Guidelines Rule 13 > CHART STUFF

  3. #3
    Moderator Macropod's Avatar
    Join Date
    Aug 2007
    Location
    Canberra, Australia
    Posts
    3,262
    Post Thanks / Like
    Mentioned
    6 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Mail Merge error

    Aside from the fact that merely changing the extension doesn't change the file type, why bother? A mailmerge will work quite happily with a xlsm data source.
    Cheers
    Paul Edstein
    [MS MVP - Word]

  4. #4
    Board Regular
    Join Date
    May 2006
    Location
    New Jersey
    Posts
    375
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Mail Merge error

    Ah
    I'll give that a try!
    Words alone cannot explain how grateful that I am to all the people here
    that take the time to help others and myself!
    Grateful member since 2006.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •