Software

Ask something
Discussion Locked

excel database to mail merge

0 helpful
2 replies

by arstemmer

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
This is awful. I completely forgot my excel and cannot find my notes. I would set up worksheet for friends to automate address labels. I would have a DB file in Excel, write concatenate formulas and load the data from across the spreadsheet to Address label format. Then export to data to a Word document to print out on Avery address labels. I cannot get the data to transpose to address label format. The data transposes to label format but it spreads across the spreadsheet through the columns instead of from top of the page down in columns. Completely drawing a blank. Where can I go to refresh my memory. Thank you in advance for your assistance.

2 replies

by tink!

I use mail merge in word daily. I type the info into an Excel sheet, then open up word documents that are linked (via merge fields) to the Excel sheet.

Most of the connection work is done in Word.

Once you have created the Excel sheet, create your label document in Word. Then insert Merge fields into the first label. Then insert the "Next Record" command into the following labels. (Found under "Insert Word Field")

There is a Mailing Label wizard in Word that can walk you through the creation of the label document.

Tink

This discussion is closed to new replies.