Avatar of Michael Spellman
Michael SpellmanFlag for United States of America asked on

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"
OutlookMicrosoft ExcelScripting Languages

Avatar of undefined
Last Comment
Chris Bottomley

8/22/2022 - Mon
Chris Bottomley

Before indicating my own capability to assist, you want an event handler in Outlook that is triggered on receive of an email to see if it has ana attachment called g22.xls.

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
SOLUTION
David Lee

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
Michael Spellman

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.
ASKER CERTIFIED SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Chris Bottomley

Glad it helped, and thank you for the grade.

Chris
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy