i have a database of addresses in access 2007. i want to print the labels out of it so that i can print those.

Question

the database contains name address place and pincode..
i want in the following format without side headings..
name
address
city
pincode.

Answer 1

You can use MS word and perform a mail merge.
Tools > Letters and Mailings > Mail Merge

The wizard will ask what type of merge. Select Lables and select you lable types ect. Later in the wizard you will be asked to select data from either a list or data base.

You can pre process your labels using a query and export to a text file or bworse directly to a database from within Word.
I am using MS 2003, there are probably some differences between MS2007 but the concept is the same. Check your MS Word help for mail merge

Answer 2

i do no longer do mail merges that in many circumstances and tend to have forgotten how I final did it! do no longer you in basic terms use the get admission to database as your archives source? So, open a rfile in observe save on with the mail merge activates (decide on the style/length of label in observe, decide on mail merge and do the sphere heading - you are going to be able to desire to make helpful the columns of archives in the database have the same headings) and then deliver to merge in a clean rfile? stable luck!