I would like to keep track of bad email addresses when they are sent via outlook and are returned.
Is it possible to have a macro so that the follwing happens:
When a sent email has a bad email address and is returned because it can't go through, the bad email address is listed in a column in excel. The excel spreadsheet would have two columns: one for the person's ID and one for bad email address.
The person's ID is in the subject of the email and will always have NCXXXXXXX, in which X is any digit number such as NC1214567.
Thank you for your assistance.