Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
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.docmanagement
Cindy M. Cindy M. is offline
external usenet poster
 
Posts: 2,416
Default Mail-Merge with Varying Data-Ranges

Hi Lisa,

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?

The better place to pursue this question would be the word.mailmerge.fields
newsgroup, where you'll find more people who specialize in mail merge.

Your described approach can work, see this KB article:
HOW TO: Use Mail Merge to Create a List Sorted by Category in Word 2000
http://support.microsoft.com?kbid=211303


Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
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
mail merging multiple columns with varying number of rows troll_mage Mailmerge 1 November 10th 05 07: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
DotNet Data Table as Mail Merge Data Source goraya Mailmerge 1 July 7th 05 09:51 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 04:12 PM.

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"