Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-05-2023, 09:56 AM
Han Champion Han Champion is offline Sending emails based on criteria and addresses in Excel sheet Windows 11 Sending emails based on criteria and addresses in Excel sheet Office 2016
Novice
Sending emails based on criteria and addresses in Excel sheet
 
Join Date: May 2023
Posts: 2
Han Champion is on a distinguished road
Thumbs up

Thank you for the response. I'm trying to automate this for an end user who is not very capable. If I understand correctly, I will attempt an Excel user form to allow the end user to select which group(s) to send an email to. The VBA code will filter the list for just 1 group's members, select the appropriate Word document and run the mailmerge. It will then loop and repeat until all the selected groups have been iterated through.

Its been several years since I programmed in VBA, so it looks like I have something to occupy my time over the holidays.
Reply With Quote
Reply

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 05:42 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