Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
susanb
 
Posts: n/a
Default Labels with more than one excel record per label

I need to create family membership cards consisting of family header
information and individual family members details. They will be printed onto
preset card sheets similar to label sheets. The source is an excel
spreadsheet with one record per family member. is there a way of doing this?
--
susanb
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Cindy M -WordMVP-
 
Posts: n/a
Default Labels with more than one excel record per label

Hi ?B?c3VzYW5i?=,

I need to create family membership cards consisting of family header
information and individual family members details. They will be printed onto
preset card sheets similar to label sheets. The source is an excel
spreadsheet with one record per family member. is there a way of doing this?

There's no simple, easy way, no.

In the Special Merges section of my website's Mail Merge FAQ you'll find a
discussion on how to handle complex merges of this type (one-to-many). None of
the approaches suggested, except the VBA one, will really work for labels that
are set up in a table, though.

Possibly, you could get the Database field approach to work if you substituted
Frames (from the Forms toolbar) for the table cells that make up a label sheet.
Tricky to get it set up, but doable. This would also mean needing to split up
the spreadsheet (or better, make copies so you still have the original) into
two separate sheets: one containing the family header information, with a "key
field" (like an ID number) that links that to the individual listings.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)

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
Merging labels from excel starts second page with second record Debbie Mailmerge 1 February 8th 06 07:17 PM
Why isn't all my Excel data merging into my Word labels document? Cindy Meister Mailmerge 0 August 6th 05 09:19 AM
creating labels, not addresses, from an Excel file some_guy79 Mailmerge 1 June 11th 05 03:54 AM
Help I am going crazy I am trying to merge a label list excel to w Archer------------> Microsoft Word Help 2 April 20th 05 06:31 AM
Printing 1 Label per Page - "Next Record" Not Working Kim Finleyson Mailmerge 0 February 1st 05 04:43 PM


All times are GMT +1. The time now is 05:58 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"