Mail Merging

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nrodADAA - 08 Mar 2007 22:10 GMT

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?

Reply to this Message

Doug Robbins - Word MVP - 09 Mar 2007 04:38 GMT

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.

Signature

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

>I am trying to mail merge an MSExcel 2000 spreadsheet into MSWord 2000.
>The
[quoted text clipped - 12 lines]
>
> What am I doing wrong?

Reply to this Message

nrodADAA - 10 Mar 2007 16:22 GMT

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.
[quoted text clipped - 21 lines]
> >
> > What am I doing wrong?

Reply to this Message

Rate this thread: