Hello All,
I'm not a coding expert and so looking for someone to help me. First of all, thanks for taking time and reading my requirement.
Requirement: I have some contents in the excel file (as shown in screenshot1) and with a click of button, I want an email to be opened with copying of excel contents into the body of the email as shown in 2nd screenshot.
Things to be noted:
1. After clicking button (running VBA script), email with excel contents to be opened but not directly send. To address and Subject are NOT mentioned in the excel file. Just open the new email with excel contents pasted into the body of the email
2. I want this NOT as an image, can excel copy the contents and paste it into the email?
******** From Cell C2 to D25. Also, please also check below point (#3).
3. There are chances that the table which I'm showing in screenshot is not fixed. Additional columns and rows can be added. Maybe this always starts from cell-C2 but high chances of adding more Columns and Rows to it. Can this table be dynamically copied and pasted? by adjusting the table borders into the email?? [Important but not a mandatory requirement].
Send Email.PNG
Expected Output_Email Generation.PNG
I'm attaching the sample worksheet for your convenience. Request to please work on this worksheet and send it back to me. Thanks a ton in advance!!
Bookmarks