Another Mail Merge Question...

[Big_Si]

Hi

I have recently developed a database for the purposes of reporting service technician visits. Using the ODBC connection to our AS400 I am able to collate the relevant visit information and display it in a report. I am having a problem with the output. Currently it creates a PDF document which is simply a carbon copy of the SNP image in the preview window, but I need to produce the document as a .doc format. I have explored the options with .rtf but it isn't really suitable as it strips all the graphics.

I have read through some of the other threads and to be honest am none the wiser

I suspect the merge it with word commands will be just the trick but so far haven't had much success. If anybody can possible point me in the right direction it would be much appreciated

thanks

 

[GaryPanic]

a possible answer might be "super easy word "

 

[GaryPanic]

you would have to remake your report in word - but once done - you have full word functionality -

 

[Big_Si]

Thanks for that Gary. I'll give it a go. Not sure it will work in quite the way I need it too though as I assume that this code requires all the data to be pulled from a single query or table? Currently the report I use is constructed from two subreports and in effect 3 queries.

Do you know if this will present a problem?

 

[GaryPanic]

it will - but the solution is to make a new table (empty at the moment and appended the qry into this table) and make a form based on this table
and when you exit the form have a delete qry to empty the table

table size 255 fields - if you need more than this then you are stuffed and you will have to VB code word - which isn't my field

 

[Big_Si]

Cool, Sounds good to me. Only got about 100 fields in total so should be ok

cheers

 

[pinstripe]

it will - but the solution is to make a new table (empty at the moment and appended the qry into this table) and make a form based on this table
and when you exit the form have a delete qry to empty the table

table size 255 fields - if you need more than this then you are stuffed and you will have to VB code word - which isn't my field

Is this the best solution to this problem? Or is there any other way to merge data if you have subforms?
thx