LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Scott Marcus
 
Posts: n/a
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Error message when using Excel to open text file orutulsa Excel Discussion (Misc queries) 2 March 14th 06 06:10 PM
"Frontpage " message appears on attempting to open excel stewart reid Excel Discussion (Misc queries) 1 September 14th 05 04:32 PM
Trying to open Excel/Word files error message "Unable to read file RobM Excel Discussion (Misc queries) 1 February 7th 05 08:11 PM
open file file then error message Piroon Saetang Excel Discussion (Misc queries) 1 February 4th 05 12:05 AM
How do I get my personal macro worksheet to open whenever I open . Claudia_R Excel Discussion (Misc queries) 3 December 9th 04 11:59 PM


All times are GMT +1. The time now is 03:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"