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 / February 2004

Tip: Looking for answers? Try searching our database.

Mail Merge with Multi values.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
fb0gris1091 - 04 Jan 2004 17:45 GMT
I have a letter mail merge that works very well with one record (order
details) per customer, but I would like to have many orders lines, dependent
on the data.  The example below, the letter for customer 1 would only show 1
order, then the letter for customer 2, 2, and customer 3, 1, and customer 4,
there would be 3 order lines.

The data source is an access database.

Eg.   Customer    Order Number
       1                    1312
       2                    3232
       2                    4352
       3                    532
       4                    6432
        4                    6423
       4                    7234

Any assistance in this would greatly be appreciated.

Thanks.
Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 04 Jan 2004 21:28 GMT
Hi fb0gris1091,

See the "Multiple items per condition" item under the "Special merges"
section of fellow MVP CIndy Meister's website at
http://homepage.swissonline.ch/cindymeister/MergFram.htm

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 letter mail merge that works very well with one record (order
> details) per customer, but I would like to have many orders lines,
[quoted text clipped - 19 lines]
>
> Thanks.
Badger - 05 Jan 2004 21:48 GMT
Hi fb0gris1091,

If you're still stuck, have a look at Microsoft QB211303or Q294686.
It gives examples with explanations.
If you're still stuck, mail me and I'll sort some sample documents for you.

Regards
Paul

> Hi fb0gris1091,
>
[quoted text clipped - 30 lines]
> >
> > Thanks.
wally - 23 Feb 2004 20:16 GMT
I just did this and it works great.  However, the new documents do not have a great naming convention.  Is there a way to have the macro use selective text to use as the name (ie. text after the 3rd carriage return until the 4th carriage return)?d
   
    ----- Doug Robbins - Word MVP - DELETE UPPERCA wrote: ----
   
    Hi fb0gris1091
   
    See the "Multiple items per condition" item under the "Special merges"
    section of fellow MVP CIndy Meister's website at
    http://homepage.swissonline.ch/cindymeister/MergFram.ht
   
    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 help
    Doug Robbins - Word MV
    "fb0gris1091" <fb0gris1091@rogers.com> wrote in message
    news:WiYJb.138564$INs.135438@twister01.bloor.is.net.cable.rogers.com..
    >I have a letter mail merge that works very well with one record (orde
    > details) per customer, but I would like to have many orders lines,
    > dependen
    > on the data.  The example below, the letter for customer 1 would only show
    >
    > order, then the letter for customer 2, 2, and customer 3, 1, and customer
    > 4
    > there would be 3 order lines
    >> The data source is an access database
    >> Eg.   Customer    Order Numbe
    >        1                    131
    >        2                    323
    >        2                    435
    >        3                    53
    >        4                    643
    >         4                    642
    >        4                    723
    >> Any assistance in this would greatly be appreciated
    >> Thanks
 
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.