multiple entries/imports

  • 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
 
Hi Matt,

I'm a bit confused about your terminology. Access stores data in tables
and you edit it in forms; reports are mainly intended for printed
output. AFAIK you simply can't "enter a record on the ... subreport".

Anyway, I get the impression that (a) you have a table of Persons or
Contacts with about 2000 records, and that there is a related table for
"mail contacts", with a 1 to many relationship between Persons and
MailContacts and (b) you want to create mail contact records in bulk for
a group of about 100 Persons.

You can do this if and only if you can define the group on the basis of
the data already in the database (e.g. if it's everyone whose name
begins with "N", or everyone in Wisconsin). The way to do it is:

-Start by creating a query that returns the relevant IDs from the
persons table (or whatever the key field is that links mail contacts and
persons).

-Then convert this into an append query that appends records to the mail
contacts table. Use calculated fields to create values for the other
fields in the mail contact record, e.g.
MailingDate: #12/21/2003#
Subject: "Happy Holidays"
Manager: "Matt"

-Run the query.

If you can't specify the group of people on the basis of your data (e.g.
if you have to look at each name and think "Yes, we'll send it to her"
or "No, let's leave this one till next time") then you can't automate
it.
 
Back
Top