View Single Post
  #10   Report Post  
Posted to microsoft.public.word.mailmerge.fields
donna
 
Posts: n/a
Default Mail merge directory using excel file

How do you get it to write in the 2nd column? My 2nd column has nothing in
it now.

"Doug Robbins - Word MVP" wrote:

From the Tables menu, select Properties and on the Row tab, uncheck the box
for "allowing the row to break across a page"

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"donna" wrote in message
...
Doug, I tried that and the last cell on the page doesn't have enough room,
so
the names in each for the 2 columns are continued on the next page. So
you
might have the last name and the street in the last cell in the column
with
that persons city on the next page. I need it all in one cell. I tried
"keep with next" and "keep with next" in the format screen. It didn't
work.

Also, is it possible to have the sequence be verticle? ie:
page 1
a d
b e
c f

page 2
g j
h k
i l



"Doug Robbins - Word MVP" wrote:

In the Mailmerge main document, insert a one row, two column table (if
you
want two columns) or a three column table if you want the information in
three columns. Then into each of the cells in that table, insert the
merge
fields in the configuration that you want them. Then before the first
merge
field in the second cell (and the third if you have one), insert a Next
Record field.

Now when you execute the merge to a new document, you should get what you
want.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"donna" wrote in message
...
How do I get the excel date into a table and when do I do it? Before I
start
the merge or during it. PLease be very specific, I don't know anything
about
tables.
Thanks!

"Anne Troy" wrote:

I assume you're "columns" are in your Word mail merge main document?
If
so,
labels and other mail merge layouts are often vertically centered. If
that's
the case, you should be able to click inside your Table, then
Table--Select--Table, and then Table--Properties, Cell tab and
align
TOP.

************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out the NEWsgroup stats!
Check out: www.ExcelUserConference.com

"donna" wrote in message
...
I am trying to create a directory with names and addresses, using
an
excel
file. I can do the whole thing except for one part. Each page has
2
columns. I would like each name and address to be across from
another
one
so
they line up. ie.
Jane doe John Doe
123 main st 456 Main st
anytown, USA Box 234
Any town USA

The name that comes after Jane Doe will be one line higher than the
name
that come after John Doe. How do I get them to line up? I am using
Excel
and Word 2003. Please be very specific. Don't assume I know
anything.
Someone suggested I go to
http://www.gmayor.com/convert_labels...mail_merge.htm.
That was way over my head. I couldn't get it to work.