Word merge

We love businesses that use sage. We find they are efficient which makes us more efficient, so we can reduce your accountancy fees by up to 50%. Click here to start talking to us.

Guide to creating a mail merge in Word 2000 from Sage Line 50

This guide assumes that you have already done the following:

  •     Installed ODBC Drivers
  •     Configured ODBC Drivers
  •     Installed MS Query into Word or Office

Open Word and open the tools menu select mail merge. Create your main document as you would normally, you can do labels envelopes or letters. Choose Get data and Open Data source, click on the MSQuery Button.

Double click on your sage data source

Select the Sales Ledger table and choose the fields you want to be able to merge into your document and follow the wizard, you can filter on fields so, if you included the turnover figure you could restrict you customer list to those who spent more than a certain amount.

When you return to your document you can now use insert field to add your merge fields from sage into your document and print as normal.