Automatically Email Reports to Several People

[msantelia]

I created a Macro that emails (Outlook) a custom report to an advisor that contains info about the students who are specifially assigned to the advisor. I want to create a simple button that will take the entire list of advisors and send them reports specific to them. I use a query to provide me with the list. Any thoughts?

 

[John Big Booty]

Welcome to the forum.

Perhaps the sample posted here will give you some pointers.

 

[msantelia]

John, thanks but its a bit more complicated. I want to gather student information I collected for each advisor and launch a mail merge of sorts to Outlook that send the appropriate information to each advisor automatically without having to perform a manual send for each advisor.