Easy Office
LCI Learning

Tally to Excel : Single click

Page no : 3

Kaushik (Professional) (549 Points)
Replied 06 June 2008

From Tally Help File>

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.

 

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.

 

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

 

 



VIPIN KUTUMBALE (TAX CONSULTANT) (409 Points)
Replied 07 June 2008

pl send me tally to excel utility / steps on below mail id. vkutumbale @ rediffmail.com ajayrsparikh @ yahoo.co.in

Hemant Hegde (B.Com) (118 Points)
Replied 07 June 2008

Hi people I had already uploaded this file to this site but there was some problem with it. Now it is corrected. c

 

Please go to "Accounting" section of the files page of this site. or give a search as "Tally extract " or "Data2.3.xll"


Sandeepkedia (56 Points)
Replied 07 June 2008

sandeepkediaca @ gmail.com please send

Shailesh (accounts & Excel VBA) (342 Points)
Replied 08 June 2008

Just a opinion.

In Busywin with just a click of button you can view\print\export to Excel, Trading a/c , Profit & loss a/c, balance sheet, schedules with prev. year figure in Horizantal or vertical format.

See attached screen shoot.

 


Attached File : 11 busybs.zip downloaded: 256 times



sanjay (practicing CA) (23 Points)
Replied 09 June 2008

 please send me this file my e mail id is shrisanjay1991 @ yahoo.co.in


CA G. SRINIVAS GOUD (CHARTERED ACCOUNTANTS) (28 Points)
Replied 10 June 2008

Hai friend

plz send the file to following mail id

gollapellyca @ gmail.com

regards

CA. Srinivas Goud Gollapelly


CA G. SRINIVAS GOUD (CHARTERED ACCOUNTANTS) (28 Points)
Replied 10 June 2008

Hai friend

plz send the file to following mail id

gollapellyca @ gmail.com

regards

CA. Srinivas Goud Gollapelly


CA G. SRINIVAS GOUD (CHARTERED ACCOUNTANTS) (28 Points)
Replied 10 June 2008

plz mail the above file

gollapellyca @ gmail.com


CA G. SRINIVAS GOUD (CHARTERED ACCOUNTANTS) (28 Points)
Replied 10 June 2008

plz mail the above file

gollapellyca @ gmail.com




Anandam Boddula (Accounts Officer) (21 Points)
Replied 15 June 2008

Hai this is anand

pls send to me this file on my email ID nandab7 @ gmail.com


Rushikesh (Chartered Accountant - Manager Finance)   (2375 Points)
Replied 16 June 2008

Please send it to me at rushikeshkanhed @ yahoo.co.in

Thanks a lot


Suresh (Senior Accountant) (12 Points)
Replied 18 June 2008

Pls send me to kmsuresh @ rediffmail.com


varun (C A student) (65 Points)
Replied 18 June 2008

please send me the file at vvarunmaheshwari @ gmail.com




kalpana hegde (chartered accountant) (32 Points)
Replied 23 June 2008

Please send  to my E MAIL TOO



Leave a reply

Your are not logged in . Please login to post replies

Click here to Login / Register  




Subscribe to the latest topics :

Search Forum: