error in Word mail merge using Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1306202%22%20slang%3D%22en-US%22%3Eerror%20in%20Word%20mail%20merge%20using%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1306202%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20been%20using%20mail%20merge%20for%20some%2020%20years%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20discovered%20a%20mail%20merge%20error%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20license%20for%20Office%20365%20and%20I%20am%20up%20to%20date%20on%20all%20software%3B%20the%20Excel%20spreadsheet%20is%20in%20a%20Dropbox%20as%20well%20as%20the%20Word%20document%3B%20I%20am%20on%20Windows%2010%20Pro%20and%20it%20is%20up%20to%20date%3B%208%20GB%20RAM%3B%20189%20GB%20disk%20free%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethe%20Excel%20document%20has%20unique%20field%20names%20in%20row%201%2C%20there%20are%209%2C860%20rows%20of%20good%20data%20(rows%209%2C861-11%2C012%20are%20not%20used%20in%20the%20mail%20merge)%3B%20there%20are%2098%20columns%20(almost%20all%20are%20used)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethe%20following%20columns%20do%20not%20show%20up%20correctly%3A%3C%2FP%3E%3CP%3Ethe%20data%20in%20column%20W%20(23%3B%20CRT1)%20is%20text%3B%20formatted%20General%3B%20appears%20in%20mail%20merge%20as%20%E2%80%9C12%3A00%3A00%20AM%E2%80%9D%20when%20it%20should%20be%20something%20like%20%22E1234%22%3C%2FP%3E%3CP%3Ethe%20data%20in%20column%20Y%20(25%3B%20CRT3)%20is%20text%3B%20formatted%20General%3B%20appears%20in%20mail%20merge%20as%20%E2%80%9C12%3A00%3A00%20AM%E2%80%9D%26nbsp%3Bwhen%20it%20should%20be%20something%20like%20%22E1234%22%3C%2FP%3E%3CP%3Ethe%20data%20in%20column%20AI%20(35%3B%20ALD1)%20is%20text%3B%20formatted%20General%3B%20appears%20in%20mail%20merge%20as%20%E2%80%9C0%E2%80%9D%26nbsp%3Bwhen%20it%20should%20be%20something%20like%20%22E1234%22%3C%2FP%3E%3CP%3Ethe%20data%20in%20column%20AK%20(37%3B%20MTL)%20is%20text%3B%20formatted%20General%3B%20appears%20in%20mail%20merge%20as%20%E2%80%9C0%E2%80%9D%26nbsp%3Bwhen%20it%20should%20be%20something%20like%20%22E1234%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eany%20help%20is%20appreciated%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1306202%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

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

0 Replies