Re: Automated Email Macros; Access>Word>Outlook
Welcome to the forum,
It sounds as though you could use Mail Merge to achieve this, Mail Merge in Word will allow you to use the Send Email Merge, therefore you could connect a query to use as the source and then the list could be sent out to individuals.
You wouldn't need to use VBA to do this which should make life easier.
To see if this is a viable solution for you Open Microsoft Word and then Select the Mailings Tab, in this tab Select Start Mail Merge and at the bottom select the Wizard. As you navigate the instructions on the right it should guide you.
I am on a learning curve of life, I know a little but like to share what I have learnt with others.
I am using Microsoft Office 2003 To 2016
Please remember everyone here is a volunteer, so if you have had a reply to your thread be courteous and acknowledge this.