B
bembel
trying to create a hyperlink in an excel worksheet that will bring up an
email in outlook, any ideas?
email in outlook, any ideas?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Anne Troy
Insert-->Hyperlink. On the left, choose Email address.
If that doesn't open Outlook, they hyperlink isn't the problem. Try going to
Internet Explorer and hit Tools-->Internet options, Programs tab, and make
sure Outlook is the email program.
************
Anne Troy
www.OfficeArticles.com
If that doesn't open Outlook, they hyperlink isn't the problem. Try going to
Internet Explorer and hit Tools-->Internet options, Programs tab, and make
sure Outlook is the email program.
************
Anne Troy
www.OfficeArticles.com
B
bembel
thanks for the reply, but I am tring to link a cell in excel to a sent or
recieved mail MESSAGE, to keep track of correxpondence, any ideas
recieved mail MESSAGE, to keep track of correxpondence, any ideas
B
BizMark
I do this a lot, but I don't use a 'direct' link.
What I do is save the e-Mail messages we need to keep from Outlook, a
an "Outlook Message File (*.msg)". With the message you want to sav
visible in Outlook, go to 'File', 'Save As', change the Save As Type t
the above, find the folder you want and specify a filename - just lik
saving a Word doc or Excel workbook in fact.
Then back in Excel, you can simply set normal hyperlinks ("Existin
File or Web Page") to the .msg file(s).
When the link is clicked, Windows will ask you if you are sure you wan
to open the file. Click 'Yes', and the full Outlook message window wil
appear, containing the headers, date/time stamp, recipient lists, and o
course the message and all attachments.
BizMar
What I do is save the e-Mail messages we need to keep from Outlook, a
an "Outlook Message File (*.msg)". With the message you want to sav
visible in Outlook, go to 'File', 'Save As', change the Save As Type t
the above, find the folder you want and specify a filename - just lik
saving a Word doc or Excel workbook in fact.
Then back in Excel, you can simply set normal hyperlinks ("Existin
File or Web Page") to the .msg file(s).
When the link is clicked, Windows will ask you if you are sure you wan
to open the file. Click 'Yes', and the full Outlook message window wil
appear, containing the headers, date/time stamp, recipient lists, and o
course the message and all attachments.
BizMar
B
bembel
thanks, GREAT advice!!!
William
William