Hi , I'm sure this is something that I should know but i'm still a bit of a beginner.
I have a VBA form to input data to a spreadsheet. When you enter the details it gives the option to email the info to the required person. It brings it up as a draft so you can add or change anything before you press send. Most of the time it will work fine but occasionally will just keep popping up a new draft email and the only way to stop this happening is to close the excel sheet.
It's annoying me that it doesn't happen every time. Can anyone help with this?
I have a VBA form to input data to a spreadsheet. When you enter the details it gives the option to email the info to the required person. It brings it up as a draft so you can add or change anything before you press send. Most of the time it will work fine but occasionally will just keep popping up a new draft email and the only way to stop this happening is to close the excel sheet.
It's annoying me that it doesn't happen every time. Can anyone help with this?
