This may be wishful thinking however I thought that I would ask, can the data sheet or results from the Roll Up tab be emailed to the agent when the Send icon is selected?
I'm trying to eliminate the printing of the document and email the document instead. Since the same workbook is used for multiple agents, can a field be created to enter the email address for the agent?
QR. 2.9.16.xlsm
Check this link and see if it helps..
http://www.rondebruin.nl/win/section1.htm
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
Thank you for your assistance. I am a little confused about entering the code to email the screen image from cells A1: N33 when there is an existing code.
Will this give me the option to change the email address as well. I'm new to VBA and still learning.
This might get you closer to what you want. Assign it to your Send button.
I changed this line
Please Login or Register to view this content.
to .Display so that it will open the email and let you type in the email address.Please Login or Register to view this content.
The code came from the following link
http://www.rondebruin.nl/win/s1/outlook/bmail2.htm
Thank you I will try it.
You are welcome, let me know if it works for you or not.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks