Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / May 2004

Tip: Looking for answers? Try searching our database.

Duplicate record on each sheet

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Andy Holman - 13 May 2004 18:58 GMT
I have a spreadsheet with 100 unique names. I.e:
A
B
C...

When I create labels, I have a page with a table, and each
table contains the address fields I want to print.
Besides the first record, each other cell of the table
also has a "next record" callout in it.

The problem is that sheet 1 is okay, but sheet 2 starts
all of the addresses again beginning with the 2nd record
in the spreadsheet.
So sheet one would start with "A, B, C..." and sheet 2
starts with "B, C, D...".

HELP!
Doug Robbins - Word MVP - 14 May 2004 06:08 GMT
You need to start this as a label type mailmerge.  Sounds like to you
started with a form letter and tried to turn it into a label.

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested.  Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

> I have a spreadsheet with 100 unique names. I.e:
> A
[quoted text clipped - 13 lines]
>
> HELP!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.