Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
JR JR is offline
external usenet poster
 
Posts: 29
Default how to repeat content while using mail merge

Hello, I am pulling in data from a database into an Excel Sheet; I need to
title one field and most importantly, I need to repeat content so I can print
multiple labels with the same content. I'm having difficulty doing so in an
automated fashion. Any help out there?

Thanks!

Details:
My two fields a Name & Account Number

I want the label to read:
Roe, Julie
Account: 123

I need 10 labels each of the same label. So I would have 3 separate persons
on one label sheet (3 x 10). I'm using Avery 5366
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Andrea Jones Andrea Jones is offline
external usenet poster
 
Posts: 24
Default how to repeat content while using mail merge

You could set up one sheet of labels to accommodate 3 people. If you use the
mail merge wizard to create your labels it will put a {Next Record} field at
the start of each label on the sheet. Press ALT + F9 to display all the
field codes on your labels and remove the {Next} fields from the first 10
labels and labels 12-19 and 21-30 so you only have a {Next} field on labels
11 and 21 (going left to right from the top). This will mean that Word will
produce labels for the first person until it reaches the first {Next} field
when it will take the next record from the database and use that for the next
10 labels.

A Jones
Mastering Mail Merge Using Microsoft Word 2000 ISBN 1-906025-00-2

"JR" wrote:

Hello, I am pulling in data from a database into an Excel Sheet; I need to
title one field and most importantly, I need to repeat content so I can print
multiple labels with the same content. I'm having difficulty doing so in an
automated fashion. Any help out there?

Thanks!

Details:
My two fields a Name & Account Number

I want the label to read:
Roe, Julie
Account: 123

I need 10 labels each of the same label. So I would have 3 separate persons
on one label sheet (3 x 10). I'm using Avery 5366

  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
JR JR is offline
external usenet poster
 
Posts: 29
Default how to repeat content while using mail merge

Fantastic! Thank you so much Andrea!


"Andrea Jones" wrote:

You could set up one sheet of labels to accommodate 3 people. If you use the
mail merge wizard to create your labels it will put a {Next Record} field at
the start of each label on the sheet. Press ALT + F9 to display all the
field codes on your labels and remove the {Next} fields from the first 10
labels and labels 12-19 and 21-30 so you only have a {Next} field on labels
11 and 21 (going left to right from the top). This will mean that Word will
produce labels for the first person until it reaches the first {Next} field
when it will take the next record from the database and use that for the next
10 labels.

A Jones
Mastering Mail Merge Using Microsoft Word 2000 ISBN 1-906025-00-2

"JR" wrote:

Hello, I am pulling in data from a database into an Excel Sheet; I need to
title one field and most importantly, I need to repeat content so I can print
multiple labels with the same content. I'm having difficulty doing so in an
automated fashion. Any help out there?

Thanks!

Details:
My two fields a Name & Account Number

I want the label to read:
Roe, Julie
Account: 123

I need 10 labels each of the same label. So I would have 3 separate persons
on one label sheet (3 x 10). I'm using Avery 5366

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I mail merge to EMAIL from MS Word AND add a pdf attachment Lily@Insight Mailmerge 24 January 15th 07 09:33 PM
mail merging formatted content Lana Mailmerge 1 August 24th 06 10:35 AM
Can't get Word 2003 to keep data file with mail merge main documen Yourcareercoach Mailmerge 9 August 10th 06 12:19 PM
How do I repeat records in a mail merge? [email protected] Mailmerge 9 February 15th 06 05:26 PM
mail merge with attachments AS Mailmerge 5 April 9th 05 09:49 AM


All times are GMT +1. The time now is 04:29 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"