I have been using mail merge for some 20 years
I have discovered a mail merge error
I have a license for Office 365 and I am up to date on all software; the Excel spreadsheet is in a Dropbox as well as the Word document; I am on Windows 10 Pro and it is up to date; 8 GB RAM; 189 GB disk free
the Excel document has unique field names in row 1, there are 9,860 rows of good data (rows 9,861-11,012 are not used in the mail merge); there are 98 columns (almost all are used)
the following columns do not show up correctly:
the data in column W (23; CRT1) is text; formatted General; appears in mail merge as “12:00:00 AM” when it should be something like "E1234"
the data in column Y (25; CRT3) is text; formatted General; appears in mail merge as “12:00:00 AM” when it should be something like "E1234"
the data in column AI (35; ALD1) is text; formatted General; appears in mail merge as “0” when it should be something like "E1234"
the data in column AK (37; MTL) is text; formatted General; appears in mail merge as “0” when it should be something like "E1234"
any help is appreciated
