VBA to send email swithes file status

[gillyr7]

Below is a VBA that sends an email with a range from Excel in the body of the email, and the entire book as an attachment from a temporary file. It works great, except that I need the entire file to close, and it will not because a message pops up that says "Do you want to save file before switching file status". This will not let Excel close. I need to bypass that pop up message. Display Alerts = False did not work. In the bottom of the code below, there is a spot that tries to kill the temporary file, but it does not work until "No" in the pop up message is pressed. Again, I need to bypass that pop up message. Any ideas?

Please Login or Register  to view this content.

[mrice]

You might try setting the Saved property of the workbook to TRUE just before the prompt occurs. This might fool the application into thinking that the file is already saved and therefore not to prompt.

[gillyr7]

I looked over the code, and I found a displayalerts = true, which I did not find before. That is why when I tried to add a displayalerts = false, it did not do anything. Once I changed the first one, it worked. I will try your solution if something else comes up. Thanks.