MailMerge?

[Question Boy]

I am looking for some advice on how to tackle a problem.

I need to populate a report from Access.

This involve 2 distinct issues:
1. I need to pass unique information (Title, Number) relevent to the
specific project
2. I need to generate a table of all the related records in a sub-form.

I know the Super Easy MailMerge is very good and have used it in the past to
generate different doc, but don't know how to pass the general info along
with the sub-form records. The general info only needs to be passed once,
not with every record.

How can a attack this issue?

QB

 

[Albert D. Kallal]

In this case I recommend you build a report in which the "main" part of the
report is the Project record
and then a sub-report based on the related records table can be also placed
on that form.

To open/launch the report if you were on a form that was displaying the main
project record you would go:

if me.dirty = true then
me.Dirty = false
end if
docmd.OpenReport "Reportname",acViewPreview,,"id = " & me!id

You have to replace "id" with the name of the primary key in your projects
table (if you did not use id).

It not clear if you trying to send this stuff to a word doc, but reports
often loose formatting when you send them to word, so you might want to
consider sending that report to a pdf. once you get the above working.

If you REALLY must send this stuff to word, then

there are samples and ideas on how to do a merge with a "many" table 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