Hello All,
I have been a MR.Excel fan for a quite long time and many tricks have helped me a lot. Now i need something little bigger. I know the ask is big but am sure you all would be able to assist me.
I am trying to send a pdf attachment to a distribution list using a pre-defined template. The complete ask with corresponding cell details is as follows :-
1. I need a text field wherein the user would enter the unique ID & click on a button. Lets assume the unique ID is ABCD1
2. The macro will then match the unique id with the corresponding data in the column A, row would be the cell in which this unique id available. Currently i have around 1100 unique ID's
3. Pickup the distribution list from Column B and corresponding Row
4. Pickup the subject line from Column C and corresponding row
5. Insert the template from a word file that is saved on a path mentioned in the cell of Column D and corresponding Row
6. Insert signature already saved in Outlook with the name StandardTemplate
Thanks in Advance
I have been a MR.Excel fan for a quite long time and many tricks have helped me a lot. Now i need something little bigger. I know the ask is big but am sure you all would be able to assist me.
I am trying to send a pdf attachment to a distribution list using a pre-defined template. The complete ask with corresponding cell details is as follows :-
1. I need a text field wherein the user would enter the unique ID & click on a button. Lets assume the unique ID is ABCD1
2. The macro will then match the unique id with the corresponding data in the column A, row would be the cell in which this unique id available. Currently i have around 1100 unique ID's
3. Pickup the distribution list from Column B and corresponding Row
4. Pickup the subject line from Column C and corresponding row
5. Insert the template from a word file that is saved on a path mentioned in the cell of Column D and corresponding Row
6. Insert signature already saved in Outlook with the name StandardTemplate
Thanks in Advance
