Vb Macro to attach sheet and send by email

[Guest]

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

 

[Paul B]

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