Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-26-2019, 11:58 AM
devief devief is offline Is there any way to make mailmerge look at all rows for formatting? Windows 10 Is there any way to make mailmerge look at all rows for formatting? Office 2016
Novice
Is there any way to make mailmerge look at all rows for formatting?
 
Join Date: Aug 2019
Posts: 1
devief is on a distinguished road
Default Is there any way to make mailmerge look at all rows for formatting?

I have read and experienced that mailmerge only looks at the first 10-15 rows for formatting. I am using OLE and DO NOT want to use DDE. It is a problem when I have 9 digit zip codes as well as 5 digit, the 9 digit zips wont be recognized if there is not one in the first couple rows. Similarly with names that will not be recognized. They both default to 0 (I assume this is because it is defaulting to number formatting), not just in formatting, but in the actual recipient list.




So is there any way to make mailmerge reference more than the first 10-15 rows for formatting?


Thanks
Reply With Quote
  #2  
Old 08-28-2019, 02:02 AM
macropod's Avatar
macropod macropod is offline Is there any way to make mailmerge look at all rows for formatting? Windows 7 64bit Is there any way to make mailmerge look at all rows for formatting? 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

Did you read the relevant material in the Mailmerge Tips & Tricks 'Sticky' thread at the top of this forum? See: https://www.msofficeforums.com/mail-...ps-tricks.html
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is there any way to make mailmerge look at all rows for formatting? how to make a template with field and mailmerge to work together in protected mode pjkon Mail Merge 1 06-10-2019 04:35 PM
Is there any way to make mailmerge look at all rows for formatting? Help Formatting Time in A MailMerge Field JennEx Mail Merge 4 05-21-2018 06:47 PM
Is there any way to make mailmerge look at all rows for formatting? Remove blank table rows AFTER mailmerge Formd Mail Merge 5 05-11-2018 03:43 PM
Formatting data in scattered rows into rows following each other MorneDJ Excel 3 12-10-2016 12:35 AM
Problem With Formatting Mailmerge Fields revans611 Mail Merge 0 05-31-2009 06:20 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:06 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