Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
robgt robgt is offline
external usenet poster
 
Posts: 2
Default Nested data table in a word 2007 mail merge

I'm struggling to find a solution to this problem that I can see will
work on the document layout I have to produce.

Scenario:
I have a word 2007 document to merge into, this document contains some
static text in specific positions and an address.
For each address, there could be zero or more related records to
display in a table. If there are more than 11 related records, records
12 and onwards should be displayed in a table to the right of the
first one, with the same headings and structure as the first one.
There will never be more than related 22 records.

I have a "view" in a SQL Server database which collates all of the
data to populate this merge document.

The address data (including a unique ID for that address) is
replicated for every row of related data.

What I'm struggling to get my head around is how to add the code to
the word document to perform the checks I need before placing data on
the page? On top of that, I don't know how to add the related data
into the table(s).

Each address should have it's own document, and all related records
should be part of that single document (in the relevant table(s) area.

Can anyone offer a solution?
Cheers,
Rob
 
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
Word 2007 Mail Merge Data scarrigan Mailmerge 2 February 13th 09 07:41 AM
nested table word 2007 PublisherM Tables 1 October 23rd 08 06:14 PM
using an excel pivot table as data for word mail merge Anne Mailmerge 1 September 30th 08 08:03 PM
How do I mail merge data to a table in Word? woodworm Mailmerge 3 July 18th 06 07:39 PM
DotNet Data Table as Mail Merge Data Source goraya Mailmerge 1 July 7th 05 09:51 AM


All times are GMT +1. The time now is 12:07 AM.

Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"