Hello, im looking at creating a macro that would allow me to copy certain cells in excel and send out an email using outlook. In the "item to" command id like to specify a cell "B11" which refers to an email address. Is there a way to include this in the command or am i forced to specify an email address for this macro? Thanks, Oli
ActiveSheet.Range("A1:B10").Select
ActiveWorkbook.EnvelopeVisible = True
With ActiveSheet.MailEnvelope
.Introduction = "Pickup Request # 123."
.Item.To = "B11"
.Item.Subject = "Pickup request"
.Item.Send
End With
End Sub
ActiveSheet.Range("A1:B10").Select
ActiveWorkbook.EnvelopeVisible = True
With ActiveSheet.MailEnvelope
.Introduction = "Pickup Request # 123."
.Item.To = "B11"
.Item.Subject = "Pickup request"
.Item.Send
End With
End Sub
