Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Lisa Lisa is offline
external usenet poster
 
Posts: 122
Default Mail-Merge with Varying Data-Ranges

How do I create a mail-merge letter in which the number of cells in a given
column varies across recipients in my Excell spreadsheet?

In this case, I'm trying to create a mail-merge letter for customers
requesting information about the vehicles on an electronic toll tag account.
Some have only one vehicle, which is easy; but others have 20 or more. I need
this to be simple, so that reps. can enter the info on a spreadsheet quickly
and without having to think about it a lot. Hopefully they will be able to
enter the customers' contact info and acct number on one row, fill in as many
cells as they need in the vehicle column (say, through row 10 of that column)
and then start the next customer at the next row (row 11).

Closest I've been able to get is to have them fill all the other rows with
that same customer data, but of course that causes mail merge to create a
separate letter for each vehicle for the same customer. Any ideas?

  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Mail-Merge with Varying Data-Ranges

Sounds like you are probably trying to perform a "multiple items per
condition (=key field)" mailmerge which Word does not really have the
ability to do:

See the "Group Multiple items for a single condition" item on fellow MVP
Cindy Meister's website at

http://homepage.swissonline.ch/cindy...faq1.htm#DBPic


Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default...b;en-us;211303

or at:

http://cornell.veplan.net/article.aspx?&a=3815


--
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

"Lisa" wrote in message
...
How do I create a mail-merge letter in which the number of cells in a
given
column varies across recipients in my Excell spreadsheet?

In this case, I'm trying to create a mail-merge letter for customers
requesting information about the vehicles on an electronic toll tag
account.
Some have only one vehicle, which is easy; but others have 20 or more. I
need
this to be simple, so that reps. can enter the info on a spreadsheet
quickly
and without having to think about it a lot. Hopefully they will be able to
enter the customers' contact info and acct number on one row, fill in as
many
cells as they need in the vehicle column (say, through row 10 of that
column)
and then start the next customer at the next row (row 11).

Closest I've been able to get is to have them fill all the other rows with
that same customer data, but of course that causes mail merge to create a
separate letter for each vehicle for the same customer. Any ideas?



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
Mail-Merge with Varying Data-Ranges Lisa Microsoft Word Help 1 June 13th 08 11:48 AM
mail merging multiple columns with varying number of rows troll_mage Mailmerge 1 November 10th 05 06:42 PM
How to do merge with varying fields in each record? Tim Mailmerge 2 October 26th 05 07:32 PM
Word 2003 Mail Merge will not print individual pages or Ranges Rick Mailmerge 4 July 29th 05 05:07 AM
data in mail merge letter being cut off - data source field size? tgone Mailmerge 1 May 20th 05 02:10 PM


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