I'm using MS Office 2016 Desktop App on Windows 10 and looking for some functionality which I didn't find any success after searching online a lot and also contacted MS Outlook Support to only find that there is no easy way to achieve it except VBA script. Here's what I'm looking for:

We're sending individual mail to a huge bulk of people having individual information and individual attachment (I'm fine with this and have no problem because of other alternatives). However, what I want is that when the emails don't get sent successfully to few of them (because of the incorrect email provided or some other reason), I want to perform some action on the Original emails (ones which weren't delivered to the receiver instead of undeliverable mail from MS Outlook) when this happens. Possible action could be primarily printing the original mail and its attachments automatically to some other email automatically.

The reason I want this automation is that it is very difficult and burdensome to print individual emails from around 1000s of emails daily. Unfortunately, MS Outlook rules don't provide the condition for 'when email undelivered' or similar. I'm not sure if MS Outlook VBA script could help me for this case as I have no idea about VBA. I would like to know if this can be achieved with VBA script or not. Thank you in advance.

  • Welcome to Super User! Please note that superuser.com is not a free script/code writing service. If you tell us what you have tried so far (include the scripts/code you are already using) and where you are stuck then we can try to help with specific problems. You should also read How do I ask a good question?.
    – DavidPostill
    Jan 22, 2019 at 18:11
  • I'm just curious to know if it's possible with VBA scripting or not? Jan 22, 2019 at 18:15
  • stackoverflow.com/a/38303646/4539709
    – 0m3r
    Jan 25, 2019 at 20:51
  • Sorry for not being clear. I guess your link solution is concerned more with sending part. But I'm more concerned about is the automation on email if not successfully delivered. Hope this makes sense. Jan 25, 2019 at 21:00
  • Do you get returned / undeliverable email?
    – 0m3r
    Jan 25, 2019 at 21:18


Browse other questions tagged or ask your own question.