View Single Post
 
Old 09-22-2011, 06:01 AM
OTPM OTPM is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi
You can do this relatively easily. Follow the steps below:
1. Click in the cell you want the macro button to be in.
2. Click in the Insert menu.
3. Click on the Quick Parts button.
4. Click on Field.
5. Scroll down to MacroButton and click on it.
6. In the Display Text box enter something like "Send as EMail".
7. Click on EmailSend.
8. Click on OK.
9. Protect your form for FillingInForms.
When you click on the "Send as EMail" cell the current document will be placed in an email for sending.
Hope this helps.
Good luck.
Tony
Reply With Quote