Dear Gurus,
I have an excel sheet with email ids of people and also the email ids of their reporting managers.
Now I have to create multiple letters, which I am contemplating to do with Mail merge and create the messages, but when I send out the output I want the mails to be sent with CC to the reporting manager. But in the Word the email is only sent to one id and no field to capture the email id for CC.
Also the attachment is sent in word format, but I would like to send the pdf file.
I understand it can be achieved with macro.
I tried to record and do but then failed.
Some one could help me on this would really be grateful.
I have an excel sheet with email ids of people and also the email ids of their reporting managers.
Now I have to create multiple letters, which I am contemplating to do with Mail merge and create the messages, but when I send out the output I want the mails to be sent with CC to the reporting manager. But in the Word the email is only sent to one id and no field to capture the email id for CC.
Also the attachment is sent in word format, but I would like to send the pdf file.
I understand it can be achieved with macro.
I tried to record and do but then failed.
Some one could help me on this would really be grateful.