Hi all,
I'm trying to set up a mailto button that autofills information (for outlook 2010).
I don't even know if it can be done, but I'd like it to attach a file also.
The file is located in the directory: sheet 'Drive'
Filename: sheet 'Drive' cell A1 - (cell does not have extension .pdf that it may need)
The e-mail details are in sheet 'Drive'
Title - B5
Message - B6
To - B7
CC - B8.
Any input greatly appreciated!
Cheers
Luke
Here's an article that should answer all your questions.
David
(*) Reputation points appreciated.
Something like this, adapted from Ron de Bruin's site, should work for you. I would encourage you to explore his site (http://www.rondebruin.nl/win/s1/outlook/bmail4.htm) for additional assistance.
Please Login or Register to view this content.
Perhaps it was the Noid who should have avoided me...
If you are satisfied with my solution click the small star icon on the left. Thanks
1. Make a copy of your workbook and run the following code on your copy (just in case)
2. With excel open, press ALT+F11 to open the Visual Basic Editor (VBE). From the "Insert" menu, select "Module".
3. Paste the code from above into the empty white space. Close the VBE.
4. From the developer tab, choose "Macros", select the Sub Name, and click "Run".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks