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











LinkBack URL
About LinkBacks
Register To Reply

Bookmarks