Only 1 page from Excel?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John - 01 Jul 2005 03:56 GMT

It is me or is there a problem with using a spreadsheet for a data source?

When I've finished the merge and printing Word says I'm only printing 1 page
even though the merge creates 4 pages of labels.

Is there a work around to editing a label other than using the
forward/backwards arrows to "see" a label?

Thanks,

Signature

John

Reply to this Message

Doug Robbins - 01 Jul 2005 04:37 GMT

You have missed the final step of actually executing the merge.
See the article "Mailmerge Labels with Word XP" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

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

> It is me or is there a problem with using a spreadsheet for a data source?
>
[quoted text clipped - 6 lines]
>
> Thanks,

Reply to this Message

John - 01 Jul 2005 11:34 GMT

Doug,

Thanks.

The problem is that all the data is there, just not easily accessible. I
went back and redid the merge, making sure that I completed the merge, with
the same results.

Signature

John

> You have missed the final step of actually executing the merge.
> See the article "Mailmerge Labels with Word XP" on fellow MVP Graham Mayor's
[quoted text clipped - 12 lines]
> >
> > Thanks,

Reply to this Message

Doug Robbins - 01 Jul 2005 12:13 GMT

I am not sure what you mean by "just not easily accessible" but going back
the question in your original post of :

>> > Is there a work around to editing a label other than using the
>> > forward/backwards arrows to "see" a label?

You should either edit the source data, or execute the merge to a new
document and edit that.

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

> Doug,
>
[quoted text clipped - 23 lines]
>> >
>> > Thanks,

Reply to this Message

Rate this thread: