View Single Post
 
Old 07-12-2018, 08:41 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by Drakos View Post
I am using VBA to iterate through the data source and produce the report, everything is working fine except one thing, any of my data Fields that are longer the 255 characters are being truncated to 255 characters.

I find this strange because everything comes out fine if I use the same data source for an actual Mail Merge.
That suggests your process is treating those fields as text fields, whereas they need to be treated as memo fields.

That said, without seeing either the data source or the intended output, it's impossible to confirm your assessment that mailmerge can't be used.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote