Hi All!,
I've searched the fourms but I can't find anything specific to this. I'm trying to create customized letters using a data table containing names, addresses, order numbers etc.
I want a standard letter, but I want the name, address and order number to change for each letter (e.g. Dear Mr. Jones, Dear Mr.Smith, etc). I also want to print each letter and as the letter is printing, make the changes to each letter.
Any ideas of how to get started? A general direction and a hint of code should be all I need. Thanks!
What you are referring to sounds like a Mail Merge:
__1 Select the Table containing the relevant data within the Database Window.
__2 Make sure the Database Toolbar is visible. If not View, Toolbars, Database.
__3 Click the Office Links button on the Database Toolbar.
__4 Click Merge It with MS Word.
__5 Select the appropriate Option within the Microsoft Mail Merge Wizard then OK.
__6 You should now be in a Microsoft Word Document and you can work the options in the Mail Merge Toolbar which is now visible in Word.
__7 This should give you your customized letters, 1 for each Record in your Table but you must do the actual work. e.g. Insert standard text, merge fields, etc.