Hi... I have an excel table which has the below details (Sample). I would like to send out mails through outlook to individuals with their relevant details in a table. For example, if i want to send a mail for "Def", the mail should appear like this with a table
Name Subject Tag1 Tag2 Tag3 Tag4 Email ID
Abc Testmail detail1 detail2 detail3 detail4 abc@test.com
Def Testmail detail5 detail6 detail7 detail8 def@test.com
Ghi Testmail detail9 detail10 detail11 detail12 ghi@test.com
Jkl Testmail detail13 detail14 detail15 detail16 jkl@test.com
Example :
Dear Def,
Here are your details
Tag1 detail5
Tag2 detail6
Tag3 detail7
Tag4 detail8
Regards,
xyz
The above details should represent in a table.
I have been looking around google since 2 days, despite m beginner in vba codes.
Help will be highly appreciated.
Bookmarks