Can anyone tell me if it is possible to send an excel sheet by the routing method of e-mail, using a macro. I want to send a form created by excel, to three people in turn who each need to modify the form, then return it to me. Can I set up a macro to do this? Also can I assign this macro to an object in the worksheet.
V Murphy
Replies (5)
Please login or register to join the discussion.
E-mail by macro
Yes, it's possible.
Unfortunately the macro key-stroke recorder doesn't really help much, so you need to write some code to start Outlook and create an email.
Assigning the macro to an object in the worksheet is straightforward.
Edward Stansfeld
[email protected]
Macro recorder will do the trick!
Assuming that you are using Excel version 97 or better, you can set up a macro for the worksheet that you want to route using the macro recorder. Set up the worksheet, then use the macro recorder to record the next instructions:
File Menu
Send to
Routing recipient
Enter the details of the person you want to e-mail the worksheet to
Click OK to all the boxes
Click STOP on the macro recorder
Set up a button on another worksheet and assign the macro.
Every time you click, it will route the worksheet via the e-mail.
Job done!
Good Luck