[nrodADAA]

I am trying to mail merge an MSExcel 2000 spreadsheet into MSWord 2000. The
problem is, I can't get the information to stay where I have the fields.

I have it like this:
First Name Last name ID Rectype
Address First Name
Last name
City ST Zip
same info twice but on different lines when I merge it, the first name/last
name I have tabbed over always moves, I need it to stay exactly where it is
b/c I am trying to print membership cards.

What am I doing wrong?

[Doug Robbins - Word MVP]

When you say you have tabbed over, I guess you mean that you have pressed
the tab key multiple times to move the merge field to where you want it.
That is NOT how tabs are supposed to be used. You should set a tab stop at
the required location and then use the tab key ONCE to move to that
location.

Alternatively, create a table with the required cell dimensions into which
you insert the merge fields.

--
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

"nrodADAA" wrote in message
...
I am trying to mail merge an MSExcel 2000 spreadsheet into MSWord 2000.
The
problem is, I can't get the information to stay where I have the fields.

I have it like this:
First Name Last name ID Rectype
Address First Name
Last name
City ST Zip
same info twice but on different lines when I merge it, the first
name/last
name I have tabbed over always moves, I need it to stay exactly where it
is
b/c I am trying to print membership cards.

What am I doing wrong?

[nrodADAA]

Thanks Doug, that makes sense and it worked!

"Doug Robbins - Word MVP" wrote:

When you say you have tabbed over, I guess you mean that you have pressed
the tab key multiple times to move the merge field to where you want it.
That is NOT how tabs are supposed to be used. You should set a tab stop at
the required location and then use the tab key ONCE to move to that
location.

Alternatively, create a table with the required cell dimensions into which
you insert the merge fields.

--
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

"nrodADAA" wrote in message
...
I am trying to mail merge an MSExcel 2000 spreadsheet into MSWord 2000.
The
problem is, I can't get the information to stay where I have the fields.

I have it like this:
First Name Last name ID Rectype
Address First Name
Last name
City ST Zip
same info twice but on different lines when I merge it, the first
name/last
name I have tabbed over always moves, I need it to stay exactly where it
is
b/c I am trying to print membership cards.

What am I doing wrong?