469,955 Members | 2,494 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,955 developers. It's quick & easy.

Help with automated sending of report

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.

Nov 13 '05 #1
2 1935
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
jjo...@comcast.net catlovers, doglovers, birdlovers
ppet...@circe.com 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...)

Nov 13 '05 #2
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

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

22 posts views Thread by Rich | last post: by
10 posts views Thread by The Bicycling Guitarist | last post: by
3 posts views Thread by ChrisWinterscheid | last post: by
7 posts views Thread by apollonius2 | last post: by
18 posts views Thread by CenturionX | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.