I will need help sending reports!!

[ChrisTheAncient]

Before I dive in and make a complete mess of things (my usual style!) I thought I would beg for help on pitfalls and correct methods BEFORE I start.

I have made this nice database for a friend, and she will want to transmit the reports applicable to each individual recipient. I suppose that I have to 'step through' each of the reports in turn and transmit it to that individual. But I'm not that sure as the help pages didn't!

I can do reasonably simple coding in vb - as long as you point me in the correct direction gently!

TIA

Chris


*************************************
OK, I'm stoopid. But I'm good at it!
*************************************

 

[scriverb]

To transmit the reports as attachments you can use the SendObject command. We will discuss that later. You probably already have a table of recipients. This recipient table should have an email address field. If not then create a text field and put everyone's email address in it. Now let's create a table of reports for recipients. This table will be the Many in a one-to-many relationship to the recipients table linked together by a RecipientID field. Am I being clear enough. This table will have a record for each report to be sent to each recipient. Recipient 111 may have 3 records. Each will have a RecipientID of 111 and then a text field with the name of the report to be sent. When you are done this table can be used as you loop through the sending of all of your reports. You can use a query to select on the report name and link back to the email address. We can then build a string of email addresses to be used as the TO parameter when sending out a particular report.

Why don't you digest that and get back with me if you think this is what you would like to do. We can proceed from there.

Bob Scriver
Want the best answers? See FAQ181-2886
Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???

 

[ChrisTheAncient]

Bob.

That is an absolutely fabulous start! It's in words I can understand!

I already have a table of recipients - and each already has e-mail address field(s) ready. There is a table of messages to be sent - already linked.

I have a query that produces reports for all recipients which works nicely - but, of course, all reports for all recipients come up at the same time. And we'll be making it interesting by e-mailing some and faxing (via WinFax Pro) some of the others!

If it helps, I could zip you a copy of where I've got to in my labour of love so far. Just say. However, I am being very reassured by your help at a level I can follow!

It may take a while for us to get through this as I'm UK time and you're a few hours behind us! But if you're happy, so am I.

Then, later, I shall be relying on that super thread that you've done on Automatic report mailing sqid=539204.

Also, this thread building up like this could be of infinite use to other 'trainee' developers like me.

Thanks for helping and I shall pop in very regularly to see how we're getting on. You've no idea how I really appreciate the time and effort that you put into this forum and in how many (sometimes invisible) ways I've used the help you give here. And that's not sycophantic - it's genuine!

Chris

*************************************
OK, I'm stoopid. But I'm good at it!
*************************************

 

[scriverb]

Go ahead and send me you db to the email address in my profile. After I see what you have I will start posting back her the steps to a solution.

Bob Scriver
Want the best answers? See FAQ181-2886
Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???

 

[ChrisTheAncient]

Bob

It's on its way

Chris

*************************************
OK, I'm stoopid. But I'm good at it!
*************************************