scott56
07-08-2008, 10:27 PM
Hi,
I have developed an application that loops through a set of customer information and sends an email depending on certain criteria...I now want to extend that to in somes create a Letter and Label based on a Word template for the Letter and Label.
Can anyone assist with links or tips for the following
- how do I access fields within a word document from within Excel so that they can be populated with the customer information.
- is it possible to provide print preview functionality for word from within Excel so that the user can verify the correct letter and label.
- how do you specify fields within the word document so that Excel can access them
I am aware of the mail merge functionality that word offers but would like to see if it is possible to perform the create operation with the Excel data directly.
Thanks in advance
Scott
I have developed an application that loops through a set of customer information and sends an email depending on certain criteria...I now want to extend that to in somes create a Letter and Label based on a Word template for the Letter and Label.
Can anyone assist with links or tips for the following
- how do I access fields within a word document from within Excel so that they can be populated with the customer information.
- is it possible to provide print preview functionality for word from within Excel so that the user can verify the correct letter and label.
- how do you specify fields within the word document so that Excel can access them
I am aware of the mail merge functionality that word offers but would like to see if it is possible to perform the create operation with the Excel data directly.
Thanks in advance
Scott