Append received email addresses to an excel file.
I receive emails with attached spreadsheets from people each month. I would like to dynamically build a list of email addresses or usernames that I have received email with a given attachment (always called "G22.xls) from in an existing excel spreadsheet on a sheet called "received". I would then compare the emai addresses on that sheet to my sheet called "master" and produce a third sheet "needed" containing the names that are on "Master", but not listed on "received"
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sounds like what I would like. Check for the attachment & append senderName to workbook called "SubmittedReports.xls" in the worksheet "Received" in the next empty row in column B.
Thanks in advance for the help.
Thanks in advance for the help.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Glad it helped, and thank you for the grade.
Chris
Chris
If it does you want to append the sender to your existing spreadsheet.
If that sums up the request then the answer is 'can do' if you advise the path to your sheet and in my own case can wait a day or so for the work.
Chris