Try this one
http://www.rondebruin.nl/mail/folder2/files.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"ecommatt" wrote in message ...
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.