I am sending out multiple emails to my customers in my customer table manually. As it is time consuming to send to about 100-200 customers daily, I am wondering if it is possible to automate the process in access in such a way that I can load all files from a particular folder and the access application will be able to sort the files in the folder for each company based on their name in the field(e.g.CompanyABC_DailyReport,CompanyDEF_DailyR eport) before sending out.

Any advice will be appreciated.:)

Can't help, but keen to learn how to do this

I am sending out multiple emails to my customers in my customer table manually. As it is time consuming to send to about 100-200 customers daily, I am wondering if it is possible to automate the process in access in such a way that I can load all files from a particular folder and the access application will be able to sort the files in the folder for each company based on their name in the field(e.g.CompanyABC_DailyReport,CompanyDEF_DailyR eport) before sending out.

Any advice will be appreciated.:)

I feel uncertain to what your question is exactly. Do I understand correctly that you have a table with client information (like their name and email) and that you have in that table, linked to each client a directory, where each directory contains files you would like to attach to your email? You would like to be able to make a mailmerge for each client, where access would attach all files to the correct email? Is that what you ask for?

Why not export your contact details into a file from access and use mailmerge (through outlook or word) to send your emails. You can setup a document to map to fields in your export and produce individual emails for each customer.

Might be a quicker way to do it but this should work.

Why not export your contact details into a file from access and use mailmerge (through outlook or word) to send your emails. You can setup a document to map to fields in your export and produce individual emails for each customer.

Might be a quicker way to do it but this should work.

Thanks, I will give it a try.