I know it's not 100% related to coding, but there is plenty of knowledgeable folks here, someone may know the answer. I need to send a mass email (270 recipients) and each email needs to contain a pull from Excel sheet, containing data related to people that report to each recipient. So one recipient would get an email with 3-4 people, while the other recipient would get email with 10-15 different data points (like name, DOB, etc.)
I tried mail merge but it just sends multiple emails with separated data points for each person to each recipient (each recipient gets 10-15 emails related to 10-15 different people).
If there is a function in MS Office environment - what's it called? If there is resource (YT clip, etc.) would you have a link?
Many, many thanks!
You can automate Outlook from Excel, see Automating Outlook from Other Office Applications for more information. With Outlook object model you may configure whatever you need - reading the range of different cells in Excel and paste that information into the message body according to your needs.