Help with automated sending of report

[kimberly.shaffer]

Okay, I can automate sending of multiple emails with records using
Groupwise and Access DB. But now what I need to do is send multiple
fields associated with one field out automatically and can't figure out
how to do it.

For instance, my records look like this:

strEmail strGroup
jj****@comcast.net catlovers
jj****@comcast.net doglovers
jj****@comcast.net birdlovers
pp*****@circe.com catlovers
pp*****@circe.com doglovers
What I can do now is send an individual email out to each email address
with the one record; what I would like to do is send one email to each
email address with all the groups associated in one email, like:

jj****@comcast.net would get ONE email with the three group names in
the message field rather than three separate emails with each group
name in the message, and pp*****@circe.com would get ONE email with the
two group names in the message field rather than two separate (though
unique!)messages. I hope this makes sense. Newbie at writing code so
be kind. Using Access 2000 or 97, I don't care, whichever works. And
it can be text attachments, I just haven't figure out how to automate
sending out reports, either. I am finally posting after driving myself
crazy after three days.

[pietlinden]

looks like your most obvious problem is that what you *really* have
going on here is two one-to-many relationships, and you're missing a
table. Shouldn't your design be something like:

Group--(1,M)---GroupMembership---(M,1)---Person

then I guess you can use fConcatChild to get a list of all groups a
member belongs to and then send that and the e-mail address to
Outlook...

see this article...
http://www.mvps.org/access/modules/mdl0004.htm

Your final result would look something like this:
strEmail strGroup
[e-mail] catlovers, doglovers, birdlovers
[e-mail] catlovers, doglovers

so then you could just send the e-mail that way... (but then you'd have
to output the reports to rtf or something and attach them
individually...)

[kimberly.shaffer]

Uh, trying not to be dense, but could you explain this in more detail?

looks like your most obvious problem is that what you *really* have
going on here is two one-to-many relationships, and you're missing a
table. Shouldn't your design be something like:

Group--(1,M)---GroupMembership---(M,1)---Person

I don't really understand what you are saying. Sorry.

Kimberly