Hello everyone,
This is my first post on MacRumors! I hope you can all bear with any downfalls I might have in the "forum writing" department...I am the owner of a Macbook with Office 2011 installed. This post is with regards to Outlook 2011.
Yesterday I sent an email to 180+ ppl and I mistakenly put them in CC rather than BCC, thus revealing all of their email...and at the same time getting insulted from all angles...oops...
To avoid such a thing from happening again, I have been trying to learn (in the last 4hrs) about AppleScript writing...but I have been going nowhere.
I am looking to have a script that will pop-up an alert message BEFORE sending the email if the TOTAL number of recipients (regardless of whether in the TO, CC or BCC field) is over a certain number (let's say 20). The message box should of course give me the option to check again the message or send it as it is.
I have found such a solution for a macro (something I have a little bit more experience on), but I cannot seem to adapt it to the Mac world. Here is the link: http://www.slipstick.com/developer/check-messages-you-send-for-number-of-recipients/.
Here is the code for Windows from the above website:
Would anyone be able to help me? I am freaking out just thinking of the next email I will have to send to all of our clients next week!!
Thank you all in advance!
This is my first post on MacRumors! I hope you can all bear with any downfalls I might have in the "forum writing" department...I am the owner of a Macbook with Office 2011 installed. This post is with regards to Outlook 2011.
Yesterday I sent an email to 180+ ppl and I mistakenly put them in CC rather than BCC, thus revealing all of their email...and at the same time getting insulted from all angles...oops...
To avoid such a thing from happening again, I have been trying to learn (in the last 4hrs) about AppleScript writing...but I have been going nowhere.
I am looking to have a script that will pop-up an alert message BEFORE sending the email if the TOTAL number of recipients (regardless of whether in the TO, CC or BCC field) is over a certain number (let's say 20). The message box should of course give me the option to check again the message or send it as it is.
I have found such a solution for a macro (something I have a little bit more experience on), but I cannot seem to adapt it to the Mac world. Here is the link: http://www.slipstick.com/developer/check-messages-you-send-for-number-of-recipients/.
Here is the code for Windows from the above website:
Code:
Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)
Dim intRes As Integer
Dim strMsg As String
If Item.Recipients.Count > 1 Then
strMsg = "Your message " & Chr(34) & Item.Subject & Chr(34) & _
" contains " & Item.Recipients.Count & " recipients. " & vbCrLf & vbCrLf & _
"Do you want to send this message?"
intRes = MsgBox(strMsg, vbYesNo + vbExclamation, "Confirm Message Send")
If intRes = vbNo Then
' cancel send
Cancel = True
End If
End If
End Sub
Would anyone be able to help me? I am freaking out just thinking of the next email I will have to send to all of our clients next week!!
Thank you all in advance!