Mail Merging

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

Thanks Doug, that makes sense and it worked!

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