Microsoft Office Forums Access to Word Mail Merge Issue (255 characters)

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-16-2012, 08:02 PM
ChrisPine ChrisPine is offline Access to Word Mail Merge Issue (255 characters) Windows 7 32bit Access to Word Mail Merge Issue (255 characters) Office 2007
Novice
Access to Word Mail Merge Issue (255 characters)
 
Join Date: Feb 2012
Posts: 1
ChrisPine is on a distinguished road
Angry Access to Word Mail Merge Issue (255 characters)

Hi All,
i am sure this issue has been experienced by many people and i am sure that there is a solution to the problem however i cannot find it.

I feel like I have tried everything except the correct solution to get my database working properly!

The problem is that i am using a VBA module from my Access database to connect to a Word Document which conducts a mail merge.
The issue i am having is that it seems to cut off text in fields that are more then 255 characters long.
I am not merging from a table, i am merging from a query - but this shouldn't be a problem.

I have tried inserting a dummy record with lots of characters in it.
I have tried moving the larges field to the first column of the table
I have tried using DEE as a connection method to the word document



Can someone please help?
if need be i will generate a copy of the database and word document so someone can see whats going on. it wont be the version i am working off however as its quite sensitive data

Thanks in advance
Chris
Reply With Quote
  #2  
Old 02-16-2012, 10:01 PM
macropod's Avatar
macropod macropod is offline Access to Word Mail Merge Issue (255 characters) Windows 7 64bit Access to Word Mail Merge Issue (255 characters) Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,525
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Hi Chris,

Mailmerge in Word can handle memo fields with more than 255 characters. However, your query may be truncating the memo field - see http://allenbrowne.com/ser-63.html for possible causes. For a detailed discussion, and some workarounds you might try, see also http://answers.microsoft.com/en-us/o...4-f39cc70df485
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Tags
mail merge, msaccess, msword

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Access to Word Mail Merge Issue (255 characters) mail merge (more than 255 characters) allenglishboy Mail Merge 9 03-05-2013 06:52 AM
Access to Word Mail Merge Issue (255 characters) Access password blocking Word mail merge dbaldwin Mail Merge 3 04-22-2011 02:50 PM
Word 2007 mail merge issue steelervince Mail Merge 0 02-17-2010 02:26 PM
Access to Word Mail Merge Issue (255 characters) Mail Merge--different connections of Access in Single Word File. Goldenbird Mail Merge 3 06-12-2009 06:42 AM
Word / Access - Mail Merge ibuilders Mail Merge 0 07-30-2007 06:18 PM


All times are GMT -7. The time now is 04:20 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft