PDA

View Full Version : Create a Letter and Label from Excel



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

mdmackillop
07-09-2008, 12:10 AM
Hi Scott,
Have you looked at the KB for any relevant items? This item (http://vbaexpress.com/kb/getarticle.php?kb_id=818)is very useful.

scott56
07-09-2008, 03:17 PM
Thanks for that ....I reviewed the KB articles and found some that relate to accessing Word documents from Excel...

I will go from there and see how I go...

Good to get that KB access workbook I will use that now to search for help