Can I automate this task using VBA, Excel ?

Yes, this is possible. You will need to have some method of mapping the files to the email recipients. You can get a listing of the files from a folder and populate a worksheet with these. Here is one suggestion:

Please Login or Register  to view this content.

Using Dir is another

There is also coding that you can find on the web for automatically sending emails. You can search for this but you would need to make sure it works with your email program. Outlook coding would be easy to find.

You can add your email message into a worksheet and the automation can pick this up.
rgs
Ginny

Ginny, please make sure you use code tags.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

Here's an example of the Excel to Outlook code Ginny was hinting at:

Please Login or Register  to view this content.

Late Binding is great for when you've got a pretty good handle on your code, but I'd recommend using Early Binding for anyone still piecing their way through it.

The IntelliSense is invaluable for automatically providing a list of properties and methods, whereas working strictly with objects has more of a universal fit.