![]() Select References… from the context menu.Now turn on your Microsoft Outlook Object.Then in Excel VBA Editor, click on Insert.To open Excel VBA Editor, press the Alt + F11 key.First, open the Excel workbook from which you want to send the range of cells as Email.You can also send a range of cells from the worksheet using VBA Code as an Outlook Email attachment. In the Email dialogue box, enter recipient and subject.Then select the range of cells from the Email message body. You will find the current worksheet in the Email body.In the Email dialogue box, select Send the current sheet as the message body option. ![]() If you want to send only the part of your worksheet then go for the below steps: In this case, you can send a range of cells through Email. 1# Send Range Of Cell As Email Message Body In this case, you can send the range of cells from the Excel worksheet using several ways that are mentioned below.īy using these methods, you can easily select the cells and send them as an Email attachment. Then click on EmailandSaveCellValue/Tools/Macros to execute the code.NOTE: You can modify this code by changing some of the lines as per your information. ‘Restores screen updating and release Outlook Set oApp = CreateObject(“Outlook.Application”) ‘Makes a copy of the active sheet and save it toįileName = Range(“Subject”) & ” Text.xls” MailTxt = “I have attached ” & Range(“Subject”) ‘Set email details Comment out if not requiredĬonst MailTo = MailCC = MailBCC = “Please review ” & Range(“Subject”) Copy the below-given code and paste it into the Module window.įileName As String, MailSub As String, MailTxt As String You will find space for code in the Module window. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |