Vb Macro to attach sheet and send by email
 

Hi there.

I have a spreadsheet that I need to send out to contacts in different
companies for people to update and return the sheet to me. Is there a way of
writing a macro so that when a button is clicked it automatically returns the
sheet with the changes made to myself?

A problem I foresee is that not all my contacts are using MS Outlook.

Any help on this matter would be greatly appreciated.

Thanks in advance

Jamie

Vb Macro to attach sheet and send by email
 

Jamie, have a look at Ron's site here

http://www.rondebruin.nl/sendmail.htm#Workbook.

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003

"Jamie" wrote in message
...
Hi there.

I have a spreadsheet that I need to send out to contacts in different
companies for people to update and return the sheet to me. Is there a way
of
writing a macro so that when a button is clicked it automatically returns
the
sheet with the changes made to myself?

A problem I foresee is that not all my contacts are using MS Outlook.

Any help on this matter would be greatly appreciated.

Thanks in advance

Jamie