Share via

Mailmerge changes apostrophe (') to '

Anonymous
2021-09-30T12:09:40+00:00

I have Word file that mailmerges from a csv file. All apostrophes and ampersands get changed in the mailmerged file, what is causing this?

Thanks in anticipation.

Microsoft 365 and Office | Word | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Doug Robbins - MVP - Office Apps and Services 323.1K Reputation points MVP Volunteer Moderator
    2021-10-01T01:09:24+00:00

    Try opening the csv file in Excel and save it as an xlsx file and then use that as the data source.

    If you still cannot get it to work, if you send me a copy of the csv file, referencing this thread in the covering email message, I will investigate the issue.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2021-10-01T08:26:56+00:00

    Thanks for your suggestion, I tried it but I regret there is no change.

    I am sending you csv file.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2021-10-01T02:56:00+00:00

    Ok I understand, but if you could solve your problem?

    Was this answer helpful?

    0 comments
  4. Anonymous
    2021-09-30T15:47:11+00:00

    This is a Word/Mailmerge problem, nothing to do with Outlook.

    The Mailmerge function (Finish & Merge) is changing a perfectly good ' in the csv to ASCII.

    Was this answer helpful?

    0 comments
  5. Anonymous
    2021-09-30T14:43:04+00:00

    Hello eharford

    I am Arianne an independent advisor and I am happy to help you.

    From what you tell us, it is possible that you have some formats activated or deactivated.

    I leave you a link, I hope it will be of your help so that you can use and write your emails without any problem.

    https://support.microsoft.com/en-us/office/turn...*.

    I will be attentive in case you need my help.

    Good day.

    Was this answer helpful?

    0 comments