Hi,
I was wondering if there is a way to bypass the security settings by adding to the code below. I've checked out (http://www.rondebruin.nl/mail/prevent.html) but it doesn't work for me as I am using a different method to send the emails. I am using Microsoft Office 2007.
Sub Send_EMailsTEST()
Dim r As Integer
Dim emaAl As String
Dim CCList As String
Dim subjectLine As String
subjectLine = "Action Required: Update for Top Customers"
For r = 12 To 14
'Go to sheet with E-Mail list
Sheets("Jan. 2012").Select
'Store E-Mail address
Email = Range("K" & r).Value & ";" & Range("L" & r).Value
Sheets("Lists").Select
CCList = Range("F2").Value
'Go to sheet where e-mail body is
Sheets("Template").Select
'Select the range to be included in body of e-mail
Sheets("Jan. 2012").Range("A11:O11").Copy
ActiveSheet.Range("A30").Select
ActiveSheet.Paste
Sheets("Jan. 2012").Range("A" & r & ":O" & r).Copy
ActiveSheet.Range("A31").Select
ActiveSheet.Paste
ActiveSheet.Range("A3:A33").Select
'Start E-Mail
ActiveWorkbook.EnvelopeVisible = True
With ActiveSheet.MailEnvelope
'Set the to address from the earlier stored variable
.Item.To = Email
.Item.CC = CCList
'Set subject line based on range
.Item.Subject = subjectLine
'Send E-Mail
.Item.Send
End With
'Move to next line
Next r
Sheets("Template").Select
Rows("30:31").Select
Selection.Delete Shift:=xlUp
End Sub
Bookmarks