ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Why did this code stop working ? (https://www.excelbanter.com/excel-programming/381046-why-did-code-stop-working.html)

Corey

Why did this code stop working ?
 
Sub Outlook_Express()
ActiveSheet.Select
With ActiveWorksheet
Range("B6").Select
ActiveCell.Value = ActiveWorkbook.Worksheets.Count - 1
Range("A1:I46").Select
Dim msg As String, cell As Range
Dim Recipient As String, Subj As String, HLink As String
Dim Recipientcc As String, Recipientbcc As String
Recipient = "
Recipientcc = ActiveSheet.Range("E39")
Recipientbcc = "
Subj = ActiveSheet.Range("A47")
msg = "Dear customer" & vbNewLine & vbNewLine
For Each cell In ActiveSheet.Range("A1:I46")
msg = msg & vbNewLine & cell
Next cell
msg = WorksheetFunction.Substitute(msg, vbNewLine, "%0D%0A")
msg = WorksheetFunction.Substitute(msg, vbLf, "%0D%0A")
HLink = "mailto:" & Recipient & "?" & "cc=" & Recipientcc & "&" & "bcc=" & Recipientbcc & "&"
HLink = HLink & "subject=" & Subj & "&"
HLink = HLink & "body=" & msg
Application.SendKeys "%s"
End With

End Sub

Suddenly stopped sending the selected range ???


All times are GMT +1. The time now is 04:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com