PDA

View Full Version : sending mails from outlook using html tables with excel cell reference



rakeshr
08-20-2013, 04:54 AM
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 tableName Subject Tag1 Tag2 Tag3 Tag4 Email IDAbc Testmail detail1 detail2 detail3 detail4 abc@test.comDef Testmail detail5 detail6 detail7 detail8 def@test.comGhi Testmail detail9 detail10 detail11 detail12 ghi@test.comJkl Testmail detail13 detail14 detail15 detail16 jkl@test.comExample : Dear Def,Here are your detailsTag1 detail5Tag2 detail6Tag3 detail7Tag4 detail8Regards,xyzThe 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.