Run Outlook Macro For Received Emails.

January 2, 2012 at 20:36:10
Specs: Windows 7
I would like an outlook macro to check for some part of the subject whether or not it exists in one of the already existing excel sheet and then if that part of the subject exists in one of the columns of that existing excel sheet then it should update another new excel sheet with the subject and body for that some part of the subject.

For example,

If the subject contains some text as "123Q" then it should look for this "123Q" in the already existing excel sheet and then if this exists in that excel sheet then it should update a new excel sheet with the subject containing "123Q" and its body.And if it doesn't exists then it should just show some message that the code you are looking for doesn't exists.
Can anyone please help me on this one....

Thanks a lot in advance.


See More: Run Outlook Macro For Received Emails.

Report •


#1
January 3, 2012 at 20:25:04
Please help me on this people.

Report •

#2
January 4, 2012 at 00:17:22
If you do a Google search for something like 'Outlook macro link to excel' you'll find a number of pages that explain how you use visual basic macros to do what you want.

"I've always been mad, I know I've been mad, like the most of us..." Pink Floyd


Report •

#3
January 4, 2012 at 20:33:13
I have been googling a lot but not able to find anything useful related to this.

Report •

Related Solutions

#4
January 5, 2012 at 22:21:25
HELP MEEEEEEEEEEEEEEEEEEEEEE

Report •

#5
January 6, 2012 at 00:06:10
Have you bothered to look at some of the sites that the Google search threw up? A lot of these are from sites that have experts on visual basic, & I'm sure if you asked one of them they would be able to help. As you haven't had any responses here it would be logical to assume that there is no-one able/willing to write a macro for you.

From what I have seen of it, VB is not an overly complicated language so maybe a bit of education on your own part may also get the job done?

"I've always been mad, I know I've been mad, like the most of us..." Pink Floyd


Report •

#6
January 26, 2012 at 23:19:56
HELPPPPPPPPPPPPPPPPPPPP

Report •


Ask Question