Hi there, I'm new using macros, so there are a lot of things that I still don't understand but I require the solution for this issue.
The thing is: I need to open a specific .msg outlook file when running the excel macro using a simple Ctrl+Key.
I'm trying to follow the solution specified here http://www.mrexcel.com/forum/excel-questions/697553-macro-open-outlook-message-file.html but It's taking me more time than I expected.
Do you know a simple but yet effective solution/method for a macro like this?
I've created the .msg files in a folder on the desktop.
The macro should only open the specified .msg from a generic/static path located in the desktop folder.
I guess, I can do the If statements later to define which file to open, but right now the issue is opening any .msg file
More context:
I have a list of 1000 records/rows that are classified by the column "group" The goal is to send an email to the whole group just by reading a specific cell with the name of the group. Within the .msg file there is already the whole text and the email addresses.
I need this macro because the information is updated every day, so, there's always over 1000 (aprox) different rows daily. The information will be copied and pasted manually because the other columns are the relevant Info that the group needs to know.
I'll still be working in the answer already given in the provided link, but I hope anyone knows a way better.
The thing is: I need to open a specific .msg outlook file when running the excel macro using a simple Ctrl+Key.
I'm trying to follow the solution specified here http://www.mrexcel.com/forum/excel-questions/697553-macro-open-outlook-message-file.html but It's taking me more time than I expected.
Do you know a simple but yet effective solution/method for a macro like this?
I've created the .msg files in a folder on the desktop.
The macro should only open the specified .msg from a generic/static path located in the desktop folder.
I guess, I can do the If statements later to define which file to open, but right now the issue is opening any .msg file
More context:
I have a list of 1000 records/rows that are classified by the column "group" The goal is to send an email to the whole group just by reading a specific cell with the name of the group. Within the .msg file there is already the whole text and the email addresses.
I need this macro because the information is updated every day, so, there's always over 1000 (aprox) different rows daily. The information will be copied and pasted manually because the other columns are the relevant Info that the group needs to know.
I'll still be working in the answer already given in the provided link, but I hope anyone knows a way better.
