I want to take all the contacts from different/same excell sheet from the defined column and paste in to the outlook email.
Clear agenda is :
1. There are many contacts each line under "primary" and "backup",what ever the contacts under "primary" has to sit in "TO:" field of outlook email.
in the same way the contacts under "Backup" has to sit in "CC:" field.if any new contact is added to any list ,it has to reflect in TO and CC fields of outlook email respectively.
2.Above event must happen when you click on button in excell to send an email so that along with body,subject ,TO and CC will also be displayed in this manner.
Please see attached test file for your reference.
Hoping for your response...
Thanks in advance....