Hi folks,
I am currently trying to send emails to multiple users with respective attachments to the concerned recipients. The attachments are word based and have mail merge functions and the data is extracted from excel. All the word documents sent to the users are just one pager, and i am using mail merge to transfer the fields over, because I don't know of any other way of updating fields - if someone knows of a better way please tell me.
When there are changes addressed to the excel sheet, the word document should update. However, it does not update and i need to open the document and click yes to the 'data will be stored in this document' type message.
this defeats the purpose and ends up in me opening each word document for updating, then using the macro to send the emails with attachments out.
please help me. All help is appreciated.
I am currently trying to send emails to multiple users with respective attachments to the concerned recipients. The attachments are word based and have mail merge functions and the data is extracted from excel. All the word documents sent to the users are just one pager, and i am using mail merge to transfer the fields over, because I don't know of any other way of updating fields - if someone knows of a better way please tell me.
When there are changes addressed to the excel sheet, the word document should update. However, it does not update and i need to open the document and click yes to the 'data will be stored in this document' type message.
this defeats the purpose and ends up in me opening each word document for updating, then using the macro to send the emails with attachments out.
please help me. All help is appreciated.
