How to change the table value from Excel to outlook body
Hi Experts
I am stuck with something and I am not able to find the solution for it from last week. I tried many option and sirf net, but the end result is Zero.
I have created a Macro in VBA which send multiple mail for a go from excel to outlook. I somehow manage to get a code from Ron website to add a table in the body of the outlook. I am stuck with last option. I am looking for something like the value of the table should be changed for each mail.
I have attached the macro for your reference. I have added few sample data in the RAW_Data tab and Sheet2 tab is the table which is linked to the body of the outlook. The heading for both the sheet i.e. Sheet2 and RAW_DATA sheet is same. We can loop the code from either sheet. Is it possible to link the RAW_DATA in the body of each mail and the value of the table gets changed for every single mail.
Regards,
JD
Attachment | Size |
---|---|
Email macro.xlsm | 37.32 KB |
Recent comments
5 years 41 weeks ago
6 years 27 weeks ago
6 years 39 weeks ago
6 years 42 weeks ago
6 years 43 weeks ago
6 years 48 weeks ago
7 years 4 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago