Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 11-28-2023, 06:09 PM
Guessed's Avatar
Guessed Guessed is offline Sending emails based on criteria and addresses in Excel sheet Windows 10 Sending emails based on criteria and addresses in Excel sheet Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,176
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

The 'Mail Merge' feature of Word is not powerful enough to do your mail out in a single pass since you have a number of complicating factors that go beyond the default functionality. But you can certainly do it via a series of passes. Or if you were an advanced user doing this mailout regularly then you could create and use a macro to do it with a single click.

To get started, you need to prepare the various contents of the mailout as separate mail merge docs for each 'Group'. Once the group's email is set up, filter the merge source to remove any rows which don't have that column marked and do the mailout to those rows. Do the same for the other groups.

This means you do three mailouts (one for each group) and just filter the dataset to align with the group you want to send to.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
 

Tags
mail merge help



Similar Threads
Thread Thread Starter Forum Replies Last Post
Utilizing FORM to distribute emails based on criteria zextrot Outlook 4 10-01-2018 08:04 AM
Copy data from one sheet to another based on a certain criteria shina67 Excel Programming 2 12-28-2016 07:32 AM
need VBA to Transpose the Data from excel to word based on given criteria(status) winmaxservices2 Excel Programming 1 12-19-2014 10:21 PM
Sending emails based on criteria and addresses in Excel sheet Excel VBA Macro - Deleting Specific Data based on criteria MD011 Excel Programming 3 12-10-2014 02:15 AM
Close excel sheet before sending ? RoyLittle0 Outlook 0 10-25-2013 10:54 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:53 PM.


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