Hey guys,
I created a macro that will send massive emails by clicking a button if one cell in a particular column includes a specific wording. I.E:
If c = "BD" Or c = "BD/PD&R" Then
Dim olMail As Outlook.MailIte m
I have the whole thing, but it happens a lot that we accidentaly click the buttons and massive emails go out again an again, all I need to add is an option box before the olMail.Send that will ask me if im sure I want to send the emails.
do you know how?
it would be asweome if the message box read "Are you sure you want to send these 15 emails?" or 22 or whatever, but we really need the option box if thats not possible.
I created a macro that will send massive emails by clicking a button if one cell in a particular column includes a specific wording. I.E:
If c = "BD" Or c = "BD/PD&R" Then
Dim olMail As Outlook.MailIte m
I have the whole thing, but it happens a lot that we accidentaly click the buttons and massive emails go out again an again, all I need to add is an option box before the olMail.Send that will ask me if im sure I want to send the emails.
do you know how?
it would be asweome if the message box read "Are you sure you want to send these 15 emails?" or 22 or whatever, but we really need the option box if thats not possible.