Mail Merge: cannot display the field in Excel correctly

		Microsoft Office Forums > Microsoft Word > Mail Merge
Mail Merge: cannot display the field in Excel correctly

FAQ

Thread Tools

Display Modes

08-16-2012, 12:05 AM

macropod

Windows 7 64bit Mail Merge: cannot display the field in Excel correctly

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,516

As I said:

Quote:

Where you have numerous empty cells or mixed numbers and text in the first 16 rows in a column, you are liable to have 0s instead of the text in the mailmerge output.

If you want to know the gory details, see 'How the OLE DB determines the data type for a column' at: http://tips.pjmsn.me.uk/t0003.htm

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
time field issue in mail merge	Aude	Mail Merge	16	05-18-2014 06:22 AM
Import field from Excel to Powerpoint	xgravity23	Office	8	11-22-2012 02:08 PM
Mail merge will not format date field generated by Excel IF statement	borntorun75	Mail Merge	3	12-16-2011 06:28 AM
currency not showing correctly on mail merge	tonywatsonmail	Mail Merge	1	12-07-2011 04:29 PM
Date not transfering to mail merge correctly	tonywatsonmail	Mail Merge	1	07-01-2011 05:30 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:48 AM.