The prerequisites of Mailing Lables
In printing mailing labels through word few prerequisites has to be taken care of. The first one is that all the addresses of ledgers would be properly filled in Tally with full details like contact person, pincode, state and ofcorse full mailing address. If some thing is missing then it has to be completed before hand.
Second thing is that one should have full knowldge of the whole process of mail merge or printing mailing labels. I would provide a brief outline of the whole process but this has been explained here, Here and Here. These three sources would give you detailed idea about printing labels.
The main steps involved are :-
1. Selecting the main document.
2. Selecting the data source.
3. Merging the data with the main document to form labels.
Here second step of selecting the data source has to be done by selecting the excel file we would make now from Tally its self.
Start Tally, Open the company you want the labels to be printed. Be sure the ODBC Server is written on Tally panel. Now minimize the Tally and start UDI Magic. In Tally to Excel section give following command.
Select $LedgerContact, $MailingName, $_address1, $_address2, $_address3, $_address4, $_address5, $PinCode, $StateName from Ledger where $$IsChildOf:$$GroupSundryDebtors
Press the button View in Excel and this data extracted would be added to an excel file. Save this file and pick this file while performing the step 2 of Selecting the data source. Fix the size of the labels and print and fix the fields in a good order. All your sundry debtors would get a label. Following command can be given to print the lit of all Sundry creditors.
Select $LedgerContact, $MailingName, $_address1, $_address2, $_address3, $_address4, $_address5, $PinCode, $StateName from Ledger where $$IsChildOf:$$Creditors
Related Articles : Complete Tutorials
Hi,
I invite you and all bloggers to contentxn.com
http://www.contentxn.com/contentxn/pub_register.php
We look forward to working with you.
Navneet,
http://www.contentxn.com
contentxn.com is a good program.
I've never heard of it before, I'll be sure to check it out.
I haven't heard of it either, I'll be sure to check it out as well