Try the following link

http://www.excelkb.com/article.aspx?...3&cNode=5V1C8G

may need to be adapted in your instance, but will give you a basic idea

HTH

"ecommatt" wrote:

A mind bending question for all of you.

I have a list of company names and account numbers. Each week I must send
them a 'terms file' this is a .tmf or .dsc file (our own suffixes) what I
would like is to use send to or VB to create a button per company that does
the following;

Opens a new e-mail (outlook 2007)
Enters there e-mail or e-mail's
Enters a subject
Enters a body of text
Attaches the tmf or dsc from a folder to the e-mail.

I can do all but the last step using the send to command in excel, but with
the recent upgrade to MS office 2007 and my lack of VB skills I was wondering
if the attaching could be done automatically.