multiple subreport entries

  • Thread starter Thread starter Matt Edwards
  • Start date Start date
M

Matt Edwards

I have a database with 2000 names. Each report has a
couple of subreports, including one subreport to record
mail contacts for each name. Ordinarily I use a form with
several subform tabas to record information.

I need to send a mailing to about 100 people out of this
group of 2000. I would rather not enter a record on the
mail contacts subreport one at a time.

Is there a creative way that I can enter a subreport entry
on all 100 reports at the same time? How can I track mass
mailings to different people on the mail contacts
subreport without individual data entry?

Thanks,

-ME
 
If there is some way you can isolate the records you wish
to address than you could use an update query to mark
certain records to apply to a specific report. The query
is a very powerful tool but I can not give you any
specifics with the information you provided.
Hope this helps.
Fons
 
Matt,

First of all, it would appear that you are confusing the use of the
words Form and Report. You can't use a report for entry of data or
selection of records... most likely you need to do this on a form.

Now, these 100 people you want to send the email to... How do you
decide which ones they are? Are they actually individually selected,
or are they identified by being in certain categories as distinct from
those who don't get the email? It soulds like there can be more than
one email address entered for each person... do you want the email to
go to all addresses for the 100 people?

There are ways to do what you want, using queries, and perhaps a form
listing all records with a checkbox to select the intended recipients.
But the details will depend on the details of what you are really
trying to achieve.

In the meantime, Total Access Emailer from www.fmsinc.com is great for
batch handling of emails.

- Steve Schapel, Microsoft Access MVP
 
Back
Top