LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
bembel
 
Posts: n/a
Default is it possible to link a cell in excel to a mail in outlook?


thanks, GREAT advice!!!

William


"BizMark" wrote:


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, as
an "Outlook Message File (*.msg)". With the message you want to save
visible in Outlook, go to 'File', 'Save As', change the Save As Type to
the above, find the folder you want and specify a filename - just like
saving a Word doc or Excel workbook in fact.

Then back in Excel, you can simply set normal hyperlinks ("Existing
File or Web Page") to the .msg file(s).

When the link is clicked, Windows will ask you if you are sure you want
to open the file. Click 'Yes', and the full Outlook message window will
appear, containing the headers, date/time stamp, recipient lists, and of
course the message and all attachments.

BizMark


--
BizMark



 
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
Linking Excel to Outlook?? Pegasusnb7 Excel Discussion (Misc queries) 1 May 5th 05 10:32 PM
Stop excel emedding (opeing in mail format) when outlook is open. Help Hey New Users to Excel 1 April 26th 05 02:29 PM
How do I link many cells to one particular cell? fish@divi Excel Discussion (Misc queries) 2 January 4th 05 11:00 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM
Is there a way to link a received outlook email to a cell? Robert Kaplan Excel Worksheet Functions 1 October 31st 04 08:22 AM


All times are GMT +1. The time now is 03:34 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"