General discussion


excel database to mail merge

By arstemmer ·
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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Hope this helps

by Tink! In reply to excel database to mail me ...

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.


Collapse -

TR has some tutorials

by Beth Blakely In reply to Hope this helps

You can start here:

I agree with Tink!. There's no need to concatenate. Just be sure to set up your spreadsheet with headings that will act as "fields" in your mail merge in Word. Then you can join/print the data any way you please. Good luck!

Related Discussions

Related Forums