pass the file name written in a cell to the file path

[Megatronixs]

Hi all,

I found some code that will read the content of an outlook email. The idea would be to use this code to read the selected email. For now the path to the email is hard coded.
How could I pass the cell value to the path? (should be the current selected cell)

Please Login or Register  to view this content.

Thanks in advance.

[TMS]

Please Login or Register  to view this content.

Regards, TMS

[Megatronixs]

Hi TMS,

Thanks for the code. I actually don't have the full path of the file in the cell (I should have been more specific).
I now made some changes to refer to both differently. please see below:

Please Login or Register  to view this content.

I just can't figure out to get the MyPath and MyMsg working together.
Any idea where I go wrong?

Greetings.

[jayesh25]

You must try removing the quotes as these are variables.

Please Login or Register  to view this content.

[Megatronixs]

Hi Jayesh25,

That worked out :-)
I have no clue why I did not came up with that, just did not expect it to be so simple.

Many, many thanks.

Greetings.