ExcelVBAnovice
New Member
- Joined
- Jun 14, 2014
- Messages
- 5
Firstly, I'm not a programmer, but I dabble with Excel coding & VBA. I coded an Excel workbook 10 years ago to Email cells into the body of Outlook & it's worked great through
Office 2013, 2016 & 2021 but with Outlook 365 when clicking the 'send this section' tab, Outlook crashes
Sub Email_Instruction2()
ActiveSheet.Range("$A$1:$L$23").Select
ActiveWorkbook.EnvelopeVisible = True
With ActiveSheet.MailEnvelope
.Introduction = "Here it is"
.Item.to = "VBA@mail.com"
.Item.Cc = ""
.Item.Subject = "Returns"
End With
End Sub
The cells are text, VLOOKUP coding to bring in descriptors from a stock code & there is one small picture.
Is there anyone who can tell me how to fix this?
Thank you
Office 2013, 2016 & 2021 but with Outlook 365 when clicking the 'send this section' tab, Outlook crashes
Sub Email_Instruction2()
ActiveSheet.Range("$A$1:$L$23").Select
ActiveWorkbook.EnvelopeVisible = True
With ActiveSheet.MailEnvelope
.Introduction = "Here it is"
.Item.to = "VBA@mail.com"
.Item.Cc = ""
.Item.Subject = "Returns"
End With
End Sub
The cells are text, VLOOKUP coding to bring in descriptors from a stock code & there is one small picture.
Is there anyone who can tell me how to fix this?
Thank you