I have an MS Access database which has fields for names and addresses. The addresses are broken down into separate fields for address line 1, line 2, town/city, county, postcode etc.
I can use mailmerge to create mailing labels from these, but I often need to make just one label at a time with one address. Does anyone know of a way to export the details from these fields and paste them as an address (i.e. sort of mailmerge only one record) without having to manually copy and paste the address line by line?
It really would save me a lot of time if I could find a way!
Gary In my databases I include a checkbox and create a query to pick out the names and addresses that are ticked. The query can them be merged with your labels template to produce any 1 or more labels.
Mimram - I did something similar to your suggestion by creating a column and entering "y" for all the addresses I wanted labels for and then mailmerging these. However, the problem was that I couldn't find a simple way to remove all the "y"s from the column once I'd done the merge so that I could start again next time.
How did you create tick boxes and is there a way to reset them all to unticked?
Sorry Gary but my suggestion was for where you only want to print a single or very small number of labels from the entire database. In that case it is no problem to manually tick and then untick a couple of items.
This thread is now locked and can not be replied to.