Mailmerge directory problem

[Oreally]

I am trying to create a membership directory. I have exported the membership
data from our database into an Excel spreadsheet with fields for name,
address, email and phone number. I want to create a template I can use for
mail merge that will place each members' data in an orderly fashion in the
directory, so that the fields for name, address, email and phone number will
appear horizontally across the page, and each member's data will line up
directly underneath the other. I've tried creating a table but it doesn't
seem to work. This is an example of how I want it to look, so each field
lines up under the next one:

Mary Smith 100 Trevor Rd. Berkeley, CA 94703 845-9006 Email

Michael Jones 2 Redding St. Oakland, CA 94610 501-2893 Email

How do I do this? Thanks for your help!

 

[Suzanne S. Barnhill]

A table should work just fine. Use a "directory" or "catalog" type merge.
Create a single-row table and insert your merge fields appropriately. Make
sure that the table is set not to resize automatically. When you perform the
merge, Word will add another row for each record in your data source.

One caveat: if you add a heading row to your table, it will be repeated for
each record. There are two ways around this:

1. Add the heading row after you perform the merge.

2. Put the heading row in the page header.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org