Looking to improve bulk email process.
My users have an Access DB that they query to create a list of qualifying customers which they export to a textfile, the file has one email address per line. Next they import the list into a customer contracts folder in outlook. After that they have an Email Form they use which has the body of the email formatted, Select and insert all the recipients in as Bcc. Finally sending the message.
I am looking for ideas on how to make this less manual for them. Either something in either Outlook 2010 that will do the query through some type of macro or vb. A separate Powershell or vb script that would send the email using the .txt file as the address source. I could even do a small program in VB or C# (2005). And lastly, in Access itself (not familiar with it).
Less user intervention the better.