In a form, I have a button that creates a number of email drafts for multiple recipients, attaching a file unique to each of them.
The reason I have Access (2003) draft the email rather than send it is because a few individuals will need content added to their email message.
After clicking the command button, 50+ emails are drafted and stored in my Outook (2007) draft folder. I open up the few that need editing, and then have to mass open all of the drafts, clicking send for each one.
Is there a way to send all of the emails stored in the draft folder? Is this something in Outlook that I am just blind to? Is there a snippit of code I could put behind a separate button in Access to send everything in my Outlook draft folder?
Thanks in advance.
The reason I have Access (2003) draft the email rather than send it is because a few individuals will need content added to their email message.
After clicking the command button, 50+ emails are drafted and stored in my Outook (2007) draft folder. I open up the few that need editing, and then have to mass open all of the drafts, clicking send for each one.
Is there a way to send all of the emails stored in the draft folder? Is this something in Outlook that I am just blind to? Is there a snippit of code I could put behind a separate button in Access to send everything in my Outlook draft folder?
Thanks in advance.