Using vba in Excel to create and send batch emails in Microsoft Outlook...

Hello,

I've written some vba in Excel, to create and send a batch of emails (using Microsoft Outlook), based on info I have in an Excel Worksheet (e.g. email addresses, Salutations, etc).

The email I create using vba needs to have a file attached, and it needs to have some of the body text made bold. Once created the intention is to send the same email to many different email addresses, etc.

Currently I've not found a way, using vba, to attach a file to the template email, or make some of the email body text bold the way I would like.

Anyone ever done this before and could offer suggestions?

I've tried doing the same thing in outlook, using a pre-designed email template that has the file attached, and the necessary body text in bold, etc., but I'm unable to call this custom email template using vba. The only email that is created, via vba, is based on the standard empty template, etc.

And if I could call the custom template could I use vba to reference my Excel worksheet that contains the data I'm using?

Thank you,

Stu