ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Linking to Outlook Web Access (https://www.excelbanter.com/excel-discussion-misc-queries/219824-linking-outlook-web-access.html)

Augustine864

Linking to Outlook Web Access
 
I need to put hyperlinks in my Excel spreadsheet that will automatically open
default emails in Outlook Web Access. I had it set up to automatically open
new emails that had recipients, subjects, and body tests already filled out
in regular Outlook but the people I work for are using Outlook Web Access.
Is there a way to do this? Thanks for your help. - Alex

joel

Linking to Outlook Web Access
 
The answer I think is yes. Haven't tried it but I believe it is possible
with a macro. I tried a webquery and I can get a list of e-mails with its
status from my Outlook Web Access. but it doesn't give me a link to the
e-mail.

by writing a macro you can open a Internet Explorer Application which will
open the URL for the e-mail account. Then you can access the table of
e-mails a create a link to each unopened e-mail.

"Augustine864" wrote:

I need to put hyperlinks in my Excel spreadsheet that will automatically open
default emails in Outlook Web Access. I had it set up to automatically open
new emails that had recipients, subjects, and body tests already filled out
in regular Outlook but the people I work for are using Outlook Web Access.
Is there a way to do this? Thanks for your help. - Alex



All times are GMT +1. The time now is 08:40 AM.

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