472,354 Members | 1,451 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,354 software developers and data experts.

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 2095
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:


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

see this article...

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

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:


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


Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Rich | last post by:
I am trying to create a site that will re-direct a user based on their OS. For this site I will need to send NT4 and 95 users to site A and 2000/XP users to site B. All others should be directed...
by: The Bicycling Guitarist | last post by:
Hi. Most of my web site can pass the AAA level of Bobby, but my home page doesn't pass the single A level. AAARRGGHHH Can anyone make specific suggestions that would preserve the general...
by: ChrisWinterscheid | last post by:
We are running DB2 8.1 on AIX 5.2. DB2level shows: DB21085I Instance "db2inst1" uses "32" bits and DB2 code release "SQL08016" with level identifier "02070106". Informational tokens are "DB2...
by: James Radke | last post by:
Hello, I have a multithreaded windows NT service application (vb.net 2003) that I am working on (my first one), which reads a message queue and creates multiple threads to perform the processing...
by: SQACSharp | last post by:
I'm trying to get the control name of an editbox in another window. The following code set the value "MyPassword" in the password EditBox but it fail to return the control name of the EditBox. ...
by: Andrew Wan | last post by:
I have been developing web applications with ASP & Javascript for a long time. I have been using Visual Studio 2003.NET. While VS2003 is okay for intellisense of ASP & Javascript, it's still not...
by: apollonius2 | last post by:
Greetings, I have been working on a little project today to help me better understand classes in Python (I really like Python). I am a self taught programmer and consider myself to fall in the...
by: CenturionX | last post by:
Hello everybody, I'm using a webcontrol that gives me two probles: 1. I try to select an item in an html "select-one" control, i modify the value but it does nothing. When i navigate normally...
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and efficiency. While initially associated with cryptocurrencies...
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made but the http to https rule only works for...
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was proposed, which integrated multiple engines and...
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. header("Location:".$urlback); Is this the right layout the...
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and...
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and credentials and received a successful connection...
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific technical details, Gmail likely implements measures...
by: BLUEPANDA | last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS starter kit that's not only easy to use but also...
by: Rahul1995seven | last post by:
Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python has gained popularity among beginners and experts...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.