Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Emailing Range in Body CC Problem
I have a Workbook set up with a Send macro as below which places the Range("A51:P103") into the body
of the email. But the problem i am having is related to the CC -ing. If a sheet is sent and CC to another person, the next time a sheet needs to be emailed, the CC address from the previous sent sheet is also included. I am not sure if this is a Excel or a Outlook glitch though. Is there a solution to add to this to solve it? Has anyone else had this problem ? Corey.... Sub Send() Call Unprotect Call Hiderows Call Unprotect 'Call Hidecolumns Application.DisplayAlerts = False ' Select the range of cells on the active worksheet. ActiveSheet.Range("A51:P103").Select ' Show the envelope on the ActiveWorkbook. ActiveWorkbook.EnvelopeVisible = True On Error GoTo Macro With ActiveSheet.MailEnvelope .Introduction = "Please accept this an Official Email..." .Item.To = Range("J64") .Item.CC = Range("J65") .Item.Subject = Range("R66") .Item.Send 'Display Range("R63").Value = Date & " " & Time Call Unhiderows Range("A1").Select Macro: Call Unhiderows End With Call Protect Range("A1").Select End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mailing an excel range in the body of an e-mail | Excel Discussion (Misc queries) | |||
Emailing a template and keeping same layout as the message body | Excel Discussion (Misc queries) | |||
Emailing range for Excel and adding body text | Excel Programming | |||
Any body know how to count the cilumns in a range | Excel Discussion (Misc queries) | |||
Code problem emailing range as html in Outlook body | Excel Programming |