Hi everyone,
Can someone give me a light on creation a vba code to send emails with all relevant details based on the excel and the email format should be as per the word document.
Attached files:
1. Data (Excel file for data information)
2. Email Template (Word document for the email template)
3. Email1 Output (Word document example for one email)
4. Email2 Output (Word document example for another email)
Steps:
1. Macro to pick the excel information onto the word document. Have updated the word document in blue in color as which column information is to pick if from excel file.
2. Eventhough multiple entries for the same email id, the email should go as one email (Attahed the Email1 Output & Email2 Output pics)
- We use both excel2003 & excel 2010 Versions but outlook is 2003 version
Thank very very much for your help on this inadvance!
Regards,
Kiran
Can someone give me a light on creation a vba code to send emails with all relevant details based on the excel and the email format should be as per the word document.
Attached files:
1. Data (Excel file for data information)
2. Email Template (Word document for the email template)
3. Email1 Output (Word document example for one email)
4. Email2 Output (Word document example for another email)
Steps:
1. Macro to pick the excel information onto the word document. Have updated the word document in blue in color as which column information is to pick if from excel file.
2. Eventhough multiple entries for the same email id, the email should go as one email (Attahed the Email1 Output & Email2 Output pics)
- We use both excel2003 & excel 2010 Versions but outlook is 2003 version
Thank very very much for your help on this inadvance!
Regards,
Kiran
