Is it possible to email an excel action tracker by selecting addresses from an area on the document.
I use the below Hyperlink but have to manually put the names in the link. (this was kindly provided by Sandy666 forum member)
=HYPERLINK("mailto:[email protected]; .?cc=.&bcc=.&subject=Action Tracker%0AThis is a body text too","Email Tracker")
It would also be amazing if it attached the document.
Many thanks!
Last edited by JamesJoshua; 02-22-2016 at 12:49 PM.
Hi there,
Insert the required email address in Cell B1 and use the following formula in another cell:
Please Login or Register to view this content.
In fact, you should probably use the following version if you don't need to populate the CC and BCC fields:
Unfortunately, including an attachment is a bit more complicated and (as far as I know) probably involves calls to Windows API routinesPlease Login or Register to view this content.
Hope the above helps - please let me know how you get on.
Regards,
Greg M
Thank you it worked. Very happy man at this end! Thanks for taking the time to look at this!
Best Regards,
James
Hi again,
Many thanks for your feedback - glad I was able to help.
Best regards,
Greg M
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks