I know I am realllllllly close to getting this to work.
The problem that I am having is revolving around the code
Basically what the whole process will be is a Rule runs in Outlook and when a specific email comes in the attachment is saved in the the TPS Reports folder, then opened.... and then a couple vlookups are run on that attachment against data saved in the workbook VBDCdata.xlsx.Please Login or Register to view this content.
Then I need the data from the attachment after the vlookups have been run to be copied and pasted into the body of a reply email to the original senders.
I have this working in a text format only.... but i need that actual table format from excel. I am thinking that the error is coming from a problem with variable declarations, but not sure what it should be declared as if it should be declared?
Full code that is in outlook is below. Any help is appreciated.
Please Login or Register to view this content.
Bookmarks