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

Tip: Looking for answers? Try searching our database.

2 separate catalog merge on same page

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Rene - 23 Apr 2004 18:06 GMT
Is it possible to do two separate catalog merges on the same page?
One merge will fill the top 2/3 of the page in two columns and the
bottom 1/3 will be a new category?  For instance, I have a Corporate
listing filling most of the page and then I need a branch office
listing for the bottom third of the page.  They both have the same
columns & fields, I just need to segregate them.

Is this possible?
Charles Kenyon - 23 Apr 2004 18:56 GMT
It is possible, not easy. This is how I would approach it. Put your page
together. Perform your merge on your first database. Lock or unlink the
fields in the top 2/3. Then link to the second database and merge again. I
haven't tried or tested this but it seems like it should work.
Signature


Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

> Is it possible to do two separate catalog merges on the same page?
> One merge will fill the top 2/3 of the page in two columns and the
[quoted text clipped - 4 lines]
>
> Is this possible?
Doug Robbins - Word MVP - 24 Apr 2004 03:28 GMT
Hi Rene,

I am not sure if what Charles suggested will work.  If it doesn't if you had
all of the records in one datasource with a field indicating whether each
record belonged to Corporate or a Branch, with the records sorted by that
field then did a single catalog merge and then you run the following macro
on the document created by the merge, it may create what you want:

Dim source As Document, target As Document, scat As Range, tcat As Range
Dim data As Range, stab As Table, ttab As Table
Dim i As Long, j As Long, k As Long, n As Long
Set source = ActiveDocument
Set target = Documents.Add
Set stab = source.Tables(1)
k = stab.Columns.Count
Set ttab = target.Tables.Add(Range:=Selection.Range, numrows:=1,
numcolumns:=k - 1)
Set scat = stab.Cell(1, 1).Range
scat.End = scat.End - 1
ttab.Cell(1, 1).Range = scat
j = ttab.Rows.Count
For i = 1 To stab.Rows.Count
   Set tcat = ttab.Cell(j, 1).Range
   tcat.End = tcat.End - 1
   Set scat = stab.Cell(i, 1).Range
   scat.End = scat.End - 1
   If scat <> tcat Then
       ttab.Rows.Add
       j = ttab.Rows.Count
       ttab.Cell(j, 1).Range = scat
       ttab.Rows.Add
       For n = 2 To k
           Set data = stab.Cell(i, n).Range
           data.End = data.End - 1
           ttab.Cell(ttab.Rows.Count, n - 1).Range = data
       Next n
   Else
       ttab.Rows.Add
       For n = 2 To k
           Set data = stab.Cell(i, n).Range
           data.End = data.End - 1
           ttab.Cell(ttab.Rows.Count, n - 1).Range = data
       Next n
   End If
Next i

Signature

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

> Is it possible to do two separate catalog merges on the same page?
> One merge will fill the top 2/3 of the page in two columns and the
[quoted text clipped - 4 lines]
>
> Is this possible?
 
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.