locked
Word Mailmerge label document looses connection to data source csv file RRS feed

  • Question

  • Using Word Mailmerge  file  I want to print labels from csv file. docx is configured for a particular label size and file path.

    Message comes up - "Filename.csv is a mailmerge main document. Word cannot find its data source" then shows correct path.

    I click [Find Data Source] which shows me the file, I select it but it will not open it.

    Could you explain what is happening?

    Wednesday, October 11, 2017 9:12 AM

Answers

  • Your description suggests Filename.csv is actually a Word mailmerge main document, not a csv data file. Your mailmerge main document should have a .doc or .docx extension and should use a csv or other data file as the data source.

    I'd suggest opening your mailmerge main document and, when given the SQL prompt, answer 'no'. Then use Mailings|Select Recipients>Use Existing list to connect to an actual csv (or other) data file. Hint: True csv files are just plain text files that you can open in NotePad and, if double-clicked on, will ordinarily open in Excel - not Word.


    Cheers
    Paul Edstein
    [MS MVP - Word]

    • Proposed as answer by Steve Fan Friday, October 13, 2017 2:04 AM
    • Marked as answer by eharford Saturday, October 14, 2017 12:51 PM
    Thursday, October 12, 2017 4:00 AM
  • FileName.csv is a csv file and the mailmerge docx file is a mailmerge file.
    Not withstanding, your suggestion works fine for which many thanks.
    • Marked as answer by eharford Saturday, October 14, 2017 12:58 PM
    Saturday, October 14, 2017 12:58 PM

All replies

  • Hi eharford,

    from the description of the thread, it looks like your issue is related with user interface.

    this forum only handles the issues regarding VBA object model development related issues.

    so for better response and better solution for your issue , I move this thread to Word it pro discussions forum.

    Thanks for your understanding.

    Regards

    Deepak


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, October 12, 2017 1:44 AM
  • Your description suggests Filename.csv is actually a Word mailmerge main document, not a csv data file. Your mailmerge main document should have a .doc or .docx extension and should use a csv or other data file as the data source.

    I'd suggest opening your mailmerge main document and, when given the SQL prompt, answer 'no'. Then use Mailings|Select Recipients>Use Existing list to connect to an actual csv (or other) data file. Hint: True csv files are just plain text files that you can open in NotePad and, if double-clicked on, will ordinarily open in Excel - not Word.


    Cheers
    Paul Edstein
    [MS MVP - Word]

    • Proposed as answer by Steve Fan Friday, October 13, 2017 2:04 AM
    • Marked as answer by eharford Saturday, October 14, 2017 12:51 PM
    Thursday, October 12, 2017 4:00 AM
  • FileName.csv is a csv file and the mailmerge docx file is a mailmerge file.
    Not withstanding, your suggestion works fine for which many thanks.
    • Marked as answer by eharford Saturday, October 14, 2017 12:58 PM
    Saturday, October 14, 2017 12:58 PM