Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-05-2011, 06:27 PM
allenglishboy allenglishboy is offline mail merge  (more than 255 characters) Windows XP mail merge  (more than 255 characters) Office 2003
Novice
mail merge  (more than 255 characters)
 
Join Date: Dec 2011
Posts: 10
allenglishboy is on a distinguished road
Default mail merge (more than 255 characters)

I am trying to do a Mail Merge in WOrd 2003 from Excel file. Some of the fields are over 255 characters. I have read online that you can have fields larger than 255 charaters if you click tools> options> general and ensure that the "confirm conversion box" is checked.
I have tried to do this


When i click Open data source and browse to the file that I want to merge from I get a window that says Confirm Data Source and it has two options. The First option is OLE DB Database Files, If i click this option the merged document only has 255 characters.
If i click the second option, "Excel Files via ODBC", then i get the error message that "Word was unable to open the data source"
any help you could offer would be greatly appreciated, By the way, I am using word 2007.
Reply With Quote
  #2  
Old 12-06-2011, 04:04 AM
macropod's Avatar
macropod macropod is offline mail merge  (more than 255 characters) Windows 7 64bit mail merge  (more than 255 characters) Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

Hi allenglishboy,

There should be more than two connection options, including DDE, which you should try.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 12-06-2011, 07:04 AM
allenglishboy allenglishboy is offline mail merge  (more than 255 characters) Windows XP mail merge  (more than 255 characters) Office 2003
Novice
mail merge  (more than 255 characters)
 
Join Date: Dec 2011
Posts: 10
allenglishboy is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
Hi allenglishboy,

There should be more than two connection options, including DDE, which you should try.
DDE was not an option.


here is the fix I had to end up doing. I read online that Word looks at the first 8 entries to see if they are over 255 characters, if they are not then it truncates anything over 255 characters SO i added an arbitrary bit of text to the first field So that it was over 255 characters. Then word let all the field be over 255 characters.
Reply With Quote
  #4  
Old 12-06-2011, 03:39 PM
macropod's Avatar
macropod macropod is offline mail merge  (more than 255 characters) Windows 7 64bit mail merge  (more than 255 characters) Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

I'm glad you found a workaround. However, the lack of DDE suggests something might be awry with your Office installation. I'd suggest repairing Office via Help|Detect & Repair in any Office application.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 12-06-2011, 05:45 PM
macropod's Avatar
macropod macropod is offline mail merge  (more than 255 characters) Windows 7 64bit mail merge  (more than 255 characters) Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

Cross-posted at: http://social.technet.microsoft.com/...7-9efae34392e3
For cross-posting etiquette, please read: http://www.excelguru.ca/node/7
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #6  
Old 02-07-2012, 03:12 AM
spoednick spoednick is offline mail merge  (more than 255 characters) Windows 7 64bit mail merge  (more than 255 characters) Office 2010 32bit
Novice
 
Join Date: Feb 2012
Posts: 1
spoednick is on a distinguished road
Default thanks

i was looking all over for this problem.
Thanks!

Quote:
Originally Posted by allenglishboy View Post
DDE was not an option.


here is the fix I had to end up doing. I read online that Word looks at the first 8 entries to see if they are over 255 characters, if they are not then it truncates anything over 255 characters SO i added an arbitrary bit of text to the first field So that it was over 255 characters. Then word let all the field be over 255 characters.
Reply With Quote
  #7  
Old 03-05-2013, 03:49 AM
Bennet Bennet is offline mail merge  (more than 255 characters) Windows 7 64bit mail merge  (more than 255 characters) Office 2010 64bit
Novice
 
Join Date: Mar 2013
Posts: 2
Bennet is on a distinguished road
Default

Quote:
Originally Posted by spoednick View Post
i was looking all over for this problem.
Thanks!
I am facing the same problem, but I dont understand which field you are talking about, in excel or word?

can you also give an example?
Reply With Quote
  #8  
Old 03-05-2013, 04:20 AM
macropod's Avatar
macropod macropod is offline mail merge  (more than 255 characters) Windows 7 64bit mail merge  (more than 255 characters) Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

The reference is to every column in the Excel data source. Word evaluates them in an effort to try to establish what kind of data each column contains.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #9  
Old 03-05-2013, 06:05 AM
Bennet Bennet is offline mail merge  (more than 255 characters) Windows 7 64bit mail merge  (more than 255 characters) Office 2010 64bit
Novice
 
Join Date: Mar 2013
Posts: 2
Bennet is on a distinguished road
Default

Thank you for your reply, but can you give me an example please
Reply With Quote
  #10  
Old 03-05-2013, 06:52 AM
macropod's Avatar
macropod macropod is offline mail merge  (more than 255 characters) Windows 7 64bit mail merge  (more than 255 characters) Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

I can't see why you need an example. Fill a column in excel with a heading and any mix of data types you care to think of. That's what Word queries. Having someone else put together some random data that are totally unrealted to your situation would be meaningless.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
mail merge  (more than 255 characters) Mail Merge help mike1982 Mail Merge 1 11-21-2011 02:56 AM
mail merge  (more than 255 characters) Saving INDV mail merges During the mail merge sedain121 Mail Merge 2 10-04-2011 07:52 PM
mail merge  (more than 255 characters) Characters changing between software and mail merge output?? Calastein Mail Merge 3 05-04-2011 01:50 AM
Junk characters (box-like characters) in Word file Sashikala Word 1 04-20-2010 02:03 PM
mail merge  (more than 255 characters) mail merge Anthony Outlook 1 09-29-2009 06:09 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:34 AM.


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