Hello all,
I have searched the board for awhile now and I am unable to locate anything that is similar to my situation..
I have an excel file that generates an email... (other users will use this).
Now what I would like to do is search my inbox for the messages (they all have the same subject line).. and import the messages into excel (preferrably into a userform) but to import into an excel sheet would be acceptable as well (I think this would be the easiest option)
Right now the email that is generated by the sendmail macro creates a table and enters the information in it (this could be modified if necessary)
Name: Smoe, Joe
field2: Number
Field3: data
etc (there are 18 rows in the table and 2 columns)
i would like to extract the data from the email and place it all on one row in an excel sheet (looping thru the inbox for each message)..
any suggestions?
Thanks in advance for your help
I have searched the board for awhile now and I am unable to locate anything that is similar to my situation..
I have an excel file that generates an email... (other users will use this).
Now what I would like to do is search my inbox for the messages (they all have the same subject line).. and import the messages into excel (preferrably into a userform) but to import into an excel sheet would be acceptable as well (I think this would be the easiest option)
Right now the email that is generated by the sendmail macro creates a table and enters the information in it (this could be modified if necessary)
Name: Smoe, Joe
field2: Number
Field3: data
etc (there are 18 rows in the table and 2 columns)
i would like to extract the data from the email and place it all on one row in an excel sheet (looping thru the inbox for each message)..
any suggestions?
Thanks in advance for your help