Reply
 
Thread Tools Display Modes
  #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
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Nested data table in a word 2007 mail merge

It is not going to do exactly what you want, but see fellow MVP Macropod's
"Word 97-2007 Catalogue/Directory Mailmerge
Tutorial" at:

http://www.wopr.com/index.php?showtopic=731107

or

http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip

Do read the tutorial before trying to use the mailmerge document included
with it as you must get the mail merge main document set up exactly as
required.


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"robgt" wrote in message
...
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


  #3   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

Hi,
Thanks for the reply.
I downloaded that, read through the 22 page tutorial and I thought it
was going to be the solution for me.
Unfortunately there seems to be a sticking point for me, and that is
the table rows being repeated in the document (the nested data
portion, as it were).
I can't have a solution where macro's need to be run unfortunately.

I then tried modifying the code from the MS tutorial he
http://support.microsoft.com/kb/294686 but again, hit a hurdle
(probably lack of knowledge) with the coding side of things.
I thought I'd figured out the structure of the document using that
code, but then the same table row problem cropped up.

How do I apply the ctrl-F9 (field braces) around a table row?
I cannot figure out a way to do that...
If that can be solved, I think I've got it sorted??

I have a bad feeling that it isn't possible though?

Cheers,
Rob



On 8 July, 22:22, "Doug Robbins - Word MVP"
wrote:
It is not going to do exactly what you want, but see fellow MVP Macropod's
"Word 97-2007 Catalogue/Directory Mailmerge
Tutorial" at:

http://www.wopr.com/index.php?showtopic=731107

or

http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip

Do read the tutorial before trying to use the mailmerge document included
with it as you must get the mail merge main document set up exactly as
required.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com"robgt" wrote in message

...

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


  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Nested data table in a word 2007 mail merge

I am not sure why you would say that you cannot have a solution where a
macro needs to be run.

While I was doubtful that exactly what you wanted could be achieved via mail
merge, I am 99.9% certain that it can be accomplished by a VBA based (i.e.
macro) "roll-your-own" alternative to mail merge.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"robgt" wrote in message
...
Hi,
Thanks for the reply.
I downloaded that, read through the 22 page tutorial and I thought it
was going to be the solution for me.
Unfortunately there seems to be a sticking point for me, and that is
the table rows being repeated in the document (the nested data
portion, as it were).
I can't have a solution where macro's need to be run unfortunately.

I then tried modifying the code from the MS tutorial he
http://support.microsoft.com/kb/294686 but again, hit a hurdle
(probably lack of knowledge) with the coding side of things.
I thought I'd figured out the structure of the document using that
code, but then the same table row problem cropped up.

How do I apply the ctrl-F9 (field braces) around a table row?
I cannot figure out a way to do that...
If that can be solved, I think I've got it sorted??

I have a bad feeling that it isn't possible though?

Cheers,
Rob



On 8 July, 22:22, "Doug Robbins - Word MVP"
wrote:
It is not going to do exactly what you want, but see fellow MVP
Macropod's
"Word 97-2007 Catalogue/Directory Mailmerge
Tutorial" at:

http://www.wopr.com/index.php?showtopic=731107

or

http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip

Do read the tutorial before trying to use the mailmerge document included
with it as you must get the mail merge main document set up exactly as
required.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via
msnews.microsoft.com"robgt" wrote in message

...

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



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
Word 2007 Mail Merge Data scarrigan Mailmerge 2 February 13th 09 08: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 05:33 AM.

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"