Subscribe to this Tally Blog by Email and Enter the Lucky Draw, click on this link

17 Jan 2008

 

Tally ODBC with Microsoft Word

Consider the following scenario. A company wants to send greeting cards to its customers. It can use the names and addresses of customers, stored in the Tally database to print labels. The steps to be followed are:

  • Start Tally and keep it open till the Mail Merge process is completed.
  • Ensure ODBC Server is displayed on Tally's calculator pane.
  • Open MS Word.
  • Click on Tools > Mail Merge from the Menu bar.
  • From Main Document, click Create > Mailing Labels.
  • Click on Active Window.
  • In the Mail Merge Helper dialog box, click on Get Data > Create Data Source. Click on MS Query …from the Create Data Source dialog box.
  • Select TallyODBC from the Microsoft Query screen.
  • Query Wizard displays fields from Tally. Select Ledger and click the ">" button to select fields required in the query.

The screen appears as:


  • Use the Filter Data dialog box to limit the data to suit your requirement.
  • Sort the data in ascending or descending order in the Sort Order dialog box.
  • Click on Finish to complete the Query process.
  • Click on Set Up Main Document.
  • In Create Label dialog box, click on Insert Merge Field to insert the fields and click OK.

The screen appears as:                                      


  • Click on Merge from Mail Merge Helper dialog box to create mailing labels in a new document.

The screen appears as:


Labels: , , , ,


Comments: Post a Comment

Subscribe to Post Comments [Atom]





<< Home

This page is powered by Blogger. Isn't yours?

Subscribe to Posts [Atom]