Hi macropod,
Thank you for your kind supports. I forgot to enable Outlook reference. I just complete and it works now.
However, I am still not be able to send emails because I don't know what happens and how to fix it. When I opened letter and ran macro (Developer => Macros => Run emailmergewithattachments), the macro generated emails but without any emails in box "To", while there is a line "Firstemailaddress; secondemailaddress" in the box "CC". I attached again the files and error alert for your information. I don't know if it needs to use the function of merging mail, e.g Mailings => Finish & Merge => Send E-mail Messages.
Could you please help me to complete the VBA that will automatically take relevant emails from columns "PIC Email", "CC1", "CC2" in the Data file and put in the box "To" and "CC".
|