• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

I decided to try the mail merge function but am getting a source file error

Participant ,
Sep 21, 2023 Sep 21, 2023

Copy link to clipboard

Copied

Hi all,

 

I created a dataset in Excel with two columns, name and committee.  I saved the file as a CSV file.   In InDesign, I opened the Data Merge panel and chose "Select Data Source".   When I click on the CSV file, I get this error.
 error.jpg

When I open the file in Notepad (so I can make sure all is formatted correctly) the records are there:

Name,Committee
Bill Smith,Community
Emily Roberts,Community
Dawn Pfeifle,Community

 

What am I missing?   

Thanks

TOPICS
How to , Print

Views

114

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

Participant , Sep 21, 2023 Sep 21, 2023

Tried saving it as a tab delimited instead.  Also MUST close Excel.   Now it works. 

 

Votes

Translate

Translate
Participant ,
Sep 21, 2023 Sep 21, 2023

Copy link to clipboard

Copied

LATEST

Tried saving it as a tab delimited instead.  Also MUST close Excel.   Now it works. 

 

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines