ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   macro to open outgoing message with info (https://www.excelbanter.com/excel-discussion-misc-queries/95472-macro-open-outgoing-message-info.html)

Scott Marcus

macro to open outgoing message with info
 
I would like to put a button in every cell of column C that when pressed,
would open an outgoing message from outlook, where the subject would be the
data from column B, the "To" would be from column I, and the "CC" would be
from column D. I will type my own message. Also, column D will be only
outlook contacts. Is there a way that Excel can recognize every time I put an
outlook contact's name in and automatically make it a hyperlink, without
having to put in the address? I don't mind inputting it one time into the
worksheet if necessary.

Thanks for your help,
Scott


All times are GMT +1. The time now is 09:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com