Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 10-02-2019, 12:38 AM
macropod's Avatar
macropod macropod is offline Use only blue cells in database in mail merge Windows 7 64bit Use only blue cells in database in mail merge 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

A mailmerge cannot access content formatting in the data source. If your colouring is obtained via conditional formatting, you could either:
a) use the same formula in an extra column in your data source to return, say, 1 or 0 as appropriate, then filter the merge by that field; or
b) construct a SKIPIF field in the mailmerge main document with code that applies the same logic as your conditional formatting.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Use only blue cells in database in mail merge Mail Merge with integrated Database CarlCarl2 Mail Merge 1 01-24-2017 05:53 AM
Macro to loop through all cells in a table produced by a mail merge elh52 Word VBA 4 08-31-2014 10:50 PM
How to change a picture format so that it has dark blue points instead of light blue Appamanabha Word 0 03-28-2014 01:36 AM
Mail merge only sends some email from Access database rsakai2 Mail Merge 4 10-30-2013 10:32 PM
Use only blue cells in database in mail merge mail merge - database server rec Mail Merge 1 09-29-2013 08:03 PM

Other Forums: Access Forums

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


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