Reply
 
Thread Tools Display Modes
  #1   Report Post  
DanMurphy DanMurphy is offline
Junior Member
 
Posts: 1
Default Merge containing multiple lists

Hello

I have an Access database for which I need to set up a mail merge. Unfortunately, the merge will contain multiple lines of data, effectively forming "Lists of lists".

An extremely condensed version of the datasource is below.

LetterID,Surname,ListName,ListDetail
10,Murphy,THIS ORDER,2 Blue Widgets
10,Murphy,PREVIOUS OUTSTANDING,2 Blue Widgets
10,Murphy,PREVIOUS OUTSTANDING,2 Black Widgets
11,Collings,THIS ORDER,4 Green Widgets
12,O'Keefe,THIS ORDER,1 White Widget
12,O'Keefe,THIS ORDER,1 Yellow Widget
12,O'Keefe,PREVIOUS OUTSTANDING,3 Yellow Widgets
12,O'Keefe,PREVIOUS OUTSTANDING,2 White Widgets

As you can see, the lists can be any number of lines themselves, but some may not contain any records at all.

I know its possible to have one list of multiple lines per record in a merge, but am unsure how to set this up.

If anyone could point me in the right direction, or advise if I am attempting to square the circle it would be appreciated

Thanks in advance.
  #2   Report Post  
Natalie Lanoville Natalie Lanoville is offline
Junior Member
 
Posts: 5
Default

I haven't used it in a while, but I think the 'directory' selection as a merge document type should satisfy your requirement.
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
Copying Multiple Lists to new document dslocum[_11_] Microsoft Word Help 3 September 30th 08 12:49 AM
Multiple selections from Drop Down Lists Ozvon Microsoft Word Help 1 July 2nd 08 11:04 AM
Merge Multiple Documents with Numbered Lists [email protected] Microsoft Word Help 1 May 2nd 07 05:38 PM
How do I enumerate with multiple sequential lists? troubleabroad Tables 1 September 20th 06 03:16 PM
Can I use multiple lists when merging Ness Mailmerge 1 February 3rd 06 05:19 PM


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