Mail Merge dates in the wrong format

Problem:

I am doing a mail merge in Word with data from an Excel spreadsheet. One of the merge fields displays a date from a column in the Excel data, but the date doesn’t display in the expected format. How do I change the date format?

Answer:

  1. Open the Word Document
  2. Right click on the Date field
  3. Choose Toggle Field codes Continue reading “Mail Merge dates in the wrong format”

Preserving Number formatting using Excel data in a Word Mail Merge

If you need to preserve number formats when merging data from an Excel list into a Word mail merge, the following articles will prove useful. I think for most purposes editing the merge field from { MERGEFIELD “Price” } to { MERGEFIELD “Price” \# $#,###.00 } will be the best way. This is discussed with other options in the first article.

Steven