Using Excel as my database - how can I select specific records to move to MS word for mailing labels?

Question

I know how to make labels of the entire spreadsheet using mail merge - but cannot select only say 5 records (addresses of folks) to make those into labels - all the addresses come up. I have tried 'hide' but that only hides the records that I selected. I would like to have a database of all my addresses and then pick and chose those names I want to make address labels for.

Answer 1

You can import your Excel database into Access, then create and save a query for your specific needs. Then use mail merge in Word to merge your Access Query.

Answer 2

If you're using Word/Excel 2003, when you're at Step 3 (Select Recipients), you can use the checkboxes to the left of each row of your source data to select/deselect the row.

Only keep the checkbox next to those you want to include in your mail merge.

You can use the Select All, Clear All and Find buttons to easily select rows.

Answer 3

undecided If the above solutions gonna tutor you ways to out chum. precisely it tutor you ways to in starting to be envelopes & labels for you very own & buisness requirement. it is available in case you have a competent multi function or printer that helps a huge selection of envelopes & labels. Please talk with the link under for greater specific understanding approximately it : factors apreciated.