VBA code or macro to auto e-mail spreadsheet

[Guest]

I need some sort of "button" or "icon" to automatically attach a workbook to
an e-mail to be sent to a designated e-mail address.

I'm working in Office Standard 2007, however the majority of my co-workers
have Office Standard 2003.

I've only ever been able to get a macro or code to work when somebody off
this discussion group gave me all the steps from where to put the code, etc.
to get this done, so if anybody could help me to that extent I would greatly
appreciate it.

Please let me know what other questions you have.

Thanks,

Nancy

 

[Paul B]

Nancy, have a look at Ron's page here,
http://www.rondebruin.nl/sendmail.htm#Tips
--
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 2002 & 2003

 

[blackbox via OfficeKB.com]

Just last night I used some code from Ron's site to automate several emails.

Worked Great!

Nancy, have a look at Ron's page here,
http://www.rondebruin.nl/sendmail.htm#Tips

I need some sort of "button" or "icon" to automatically attach a workbook
to

[quoted text clipped - 15 lines]

Nancy