Send Range of Cells to Body Of Outlook 365 Without Crashing

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
 
Not solved but I'm getting closer. I started to delete the items within my sheet & testing each time. I found some conditional formatting caused 365 to freeze & crash. I added the conditional formatting back in when opened in 365 & sending Email worked OK, but if opened in other versions of Office it froze & crashed. I took the conditional formatting back out & it works in all versions of Office tested, but only works once. Reusing the sheet for a second Email freezes & crashes. When time permits, I'll try locking the sheet with VBA before sending, then unlocking after the Email has been sent.
 
Upvote 0

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Forum statistics

Threads
1,223,609
Messages
6,173,331
Members
452,510
Latest member
RCan29

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top