By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,480 Members | 763 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,480 IT Pros & Developers. It's quick & easy.

Help with automated sending of report

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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.