email

[bam12]

is there a way to when you click on a cell that it will open a particular email?

Thanks in advance for any help

 

[MDuff]

Do you mean send the sheet to an email adress or give you an email address

thanks

 

[bam12]

no

no actually when you click on the cell i want it to pulll up an email that came into me

 

[mlx]

Could you clarify a bit please?

Is there something in the cell which identifies the "email"?

When you say "open a particular email" do you mean:

1. Open an email message that you have sent or received which:

a. resides in an email client somewhere or

b. was saved as a file on your hard drive (what file type?) or

2. Open a mailer edit window in your mail client in order to compose and send an email to a particular address?

 

[bam12]

1. Open an email message that you have sent or received which:

a. resides in an email client somewhere or

 

[mlx]

In order to open an email you received it is necessary to be able to identify the email and possibly communicate with the application where the email resides.

If the email has been saved to a txt file (or other file type) then you can have excel (using VBA) launch an application (like notepad for a txt file) that can display the email if you know the filename where the email is stored.

If the email is still located in your mailer (Outlook or whatever) then to open it you need some way to communicate with that application (through VBA possibly?) and there has to be a way to locate the email and then tell that application to display it. I don't know if any mailers have this kind of access via VBA but it sounds challenging to me....

It might help if you could describe the context of your problem a bit.