Access 2003 to Word 2003 merge with nested info

[James]

Hi each
I have a table of info on people plus a related table of holidays for each
of them. I am trying to mailmerge a letter to each with their individual
details from the first table (name, address etc) and their multiple rows of
information from the second table (several different sets of holiday dates).
I need to merge it to word as it has to go on headed paper which I have as a
template in word. I have tried to reproduce this as an Access report but
cannot then email it to anyone as the graphics do not come out when it is
exported as a .rtf. Nobody else has snapshot viewer as our IT dept dont want
to use it. I understand that it is possible to export files as .pdf with
graphics from Access, but I only have Adobe reader, not a full copy.
The only way I can see to get the graphics to email is to merge to the word
template that has them on it, but I cannot work out how to merge the multiple
related holiday records.
I was trying to use a crosstab query with the individual details as row
headings then numbering the holidays as sequential column headings but
couldnt work out how to auto number the holidays so there would always be
column 1, 2, 3 etc that could be merged into a pre-made table.
Any help would be greatly appreciated!

 

[Piet Linden]

<snip>
I cannot work out how to merge the multiple
related holiday records.
</snip>

if you open an ADO recordset based on the query that returns the
records you want, you can convert the recordset to a delimited string
using GetString and then you can convert that to a table and drop it
into your document.

 

[Piet Linden]

<snip>
I cannot work out how to merge the multiple
related holiday records.
</snip>

if you open an ADO recordset based on the query that returns the
records you want, you can convert the recordset to a delimited string
using GetString and then you can convert that to a table and drop it
into your document.

 

[Albert D. Kallal]

I understand that it is possible to export files as .pdf with
graphics from Access, but I only have Adobe reader, not a full copy.

There is a free pdf solution for access here:

http://www.lebans.com/reporttopdf.htm

The above is great because you don't have to install adobe, or even install
a pdf printer...it just converts your report to pdf.

note that for access 2007, pdf ability is now built in, and you don't even
needs Stephan's solution...

If for some strange reason you can use the above free solutions, then there
is a "many" word merge example here:

http://homepage.swissonline.ch/cindymeister/MergFram.htm

look on the left side for special merges. The one you want is

Multiple items per condition

I think you should use one of the above pdf solutions as this is much less
work, and you not have to write a bunch of "word" code to create the layout
inside of an word document...

 

[Albert D. Kallal]

I understand that it is possible to export files as .pdf with
graphics from Access, but I only have Adobe reader, not a full copy.

There is a free pdf solution for access here:

http://www.lebans.com/reporttopdf.htm

The above is great because you don't have to install adobe, or even install
a pdf printer...it just converts your report to pdf.

note that for access 2007, pdf ability is now built in, and you don't even
needs Stephan's solution...

If for some strange reason you can use the above free solutions, then there
is a "many" word merge example here:

http://homepage.swissonline.ch/cindymeister/MergFram.htm

look on the left side for special merges. The one you want is

Multiple items per condition

I think you should use one of the above pdf solutions as this is much less
work, and you not have to write a bunch of "word" code to create the layout
inside of an word document...

 

[James]

Hi Piet and thanks for your help! Sadly I think my skills with Access are in
a different league as I have not come across most of what you are talking
about in your post. Your efforts on my behalf are greatly appreciated and I
will do a little more research to see if I can work out what to do.
Thank you once again for your assistance.
Kind regards

James

 

[James]

Hi Piet and thanks for your help! Sadly I think my skills with Access are in
a different league as I have not come across most of what you are talking
about in your post. Your efforts on my behalf are greatly appreciated and I
will do a little more research to see if I can work out what to do.
Thank you once again for your assistance.
Kind regards

James

 

[James]

Hi Albert and thanks very much for your help.
I had come across both of these sites in looking for help previously but
have struggled to work out how to use them.
Since your post, I have tried again with the pdf converter which seems the
slickest way of dealing with this, but am still struggling as this is beyond
my capability level!
I tried simply importing the content of the Lebans database into my database
and then clicking the "save this report as a pdf document" but this threw up
a compile error - user defined type not defined. I didnt think it would be
that simple! Sadly I am not sure how to tackle this as the code is pretty
much all gibberish to me.
Stephen Lebans does say in the readmefirst form: "You must supply the full
path and filename. Exporting your Report to Snapshot format and then
decompressing the Snapshot file is handled by functionality exposed within
this MDB. Please open the HowToUse form and examine the code behind the
CommandButton controls." but this doesnt mean very much to me I am afraid!
Thank you once again for your assistance, but if you are able to clarify
futher I would be very grateful!
Kind regards

James

 

[James]

Hi Albert and thanks very much for your help.
I had come across both of these sites in looking for help previously but
have struggled to work out how to use them.
Since your post, I have tried again with the pdf converter which seems the
slickest way of dealing with this, but am still struggling as this is beyond
my capability level!
I tried simply importing the content of the Lebans database into my database
and then clicking the "save this report as a pdf document" but this threw up
a compile error - user defined type not defined. I didnt think it would be
that simple! Sadly I am not sure how to tackle this as the code is pretty
much all gibberish to me.
Stephen Lebans does say in the readmefirst form: "You must supply the full
path and filename. Exporting your Report to Snapshot format and then
decompressing the Snapshot file is handled by functionality exposed within
this MDB. Please open the HowToUse form and examine the code behind the
CommandButton controls." but this doesnt mean very much to me I am afraid!
Thank you once again for your assistance, but if you are able to clarify
futher I would be very grateful!
Kind regards

James