How to create/set up a mail merge?

  1. Procedure
  2. Some useful resources

1. Procedure

  1. Open 'Microsoft Word' to write your text,

  2. Then click Tools > Letters and Mailings > Mail Merge...,

  3. Choose 'E-mail messages' and click 'Next',

     
  4. Choose 'Use the current document' and click 'Next'

     
  5. Choose 'Use an existing list' and click 'Browse...'

     
  6. Select in the 'Select Data Source' window your source file (Excel, Access, ...),

     
  7. Select which table or workbook you want in the file,

     
  8. By default, everything is selected, click 'OK' and click 'Next',
  9. Place the cursor where the variable field should appear,

     
  10. Click 'More items...',

     
  11. Double-click on the field you want to insert. The field now appears in the document. Click 'Next',

     
  12. Press on the arrows (left/right) to check your settings and click 'Next',

     
  13. Click on 'Electronic Mail',
  14. In the 'To' field choose the e-mail column of your database,
  15. Fill in a subject and press 'OK. Your e-mail is now being sent.

     

2. Some useful resources


Author: TESTDOMAIN\tstwouglo | Modified by: DVSM\wimpou, Tuesday October 13, 2009 17:26:14 +0200