troubleshooting Question

Streamline Outlook email process. Sending, to list exported from Access

Avatar of remmett70
remmett70Flag for United States of America asked on
Microsoft AccessProgrammingOutlook
10 Comments2 Solutions584 ViewsLast Modified:
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.
Neil Russell
Solution Development Specialist

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 10 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros