Outlook vba Application.DisplayAlerts

[jackCell]

Hi all,

I am new to outlook vba. I am trying to automate the reply of an email and record the details of the user over to an excel sheet. After writing the details to the excel sheet, I need to save the excel sheet and close it so that my Outlook automation script can continue running. I search online came across Application.DisplayAlerts. However, outlook vba does not support it. How do I work around this?

Cheers,
Jack

[jackCell]

I found my solution in this link https://www.mrexcel.com/forum/excel-questions/3965-automactically-save-changes-workbook-close.html.