Send each report page to a diff email

[Smilie]

I have a report that I run and output to a word document using rtf. Each page of this report is a release for a different cold storage. And I only want to send each cold storage (by emai) the release that applies to them.

So, depending on where the product is coming from on any particular order, there many be 1 or 5 different cold storages (and therefore pages in the report) that product needs to be released at. There are about 100 choices of cold storages, so hard coding If statments would be rather cumbersome.

Is there any easy way to do this?

The two solutions I can think of would be to either:

1. Be able to specify that I only want to email page 2 (kind of like you can say you only want to print certain pages)

OR

2. Be able to send each page into a separate word document.

Of course, I don't know how to do either of these things. Any ideas? I would love a solution to either of these or I am open to new suggestions on how to approach this problem.

Thanks!!!!

 

[Smilie]

The problem with filtering the info that I need is that I do actually need all pages. Each page is just being emailed to a different address. So, I don't want to filter them out.

I would be ok with running the report mulitple times, but I can't think of how I would pose the condition so that the first time it would run filtering for the first record, second time the second record, etc....

Any other suggestions???

 

[modest]

When you find the solution, post it, i'd be interested in it

 

[dbc1]

The answer is to carry out the process in Word rather than Access. Don't go to a report - use the underlying query to provide data (including email addresses) into the Word mailmerge. Carry out the mailmerge in Word and instead of using "letter" as the medium, choose "electronic mail" within the mailmerge helper. Each page of relevant data will then only be emailed to the email address within the record. If necessary, set up a table in Access with the recipients and their email addresses and associate this via a query with the data produced from your current database.

Try it, it does work!

 

[Smilie]

Another solution

That sounds like a good idea. What I ended up doing that worked is that I opened a form with a filter (combo with a "filter" button) that "On open" opened my multi-paged report behind it. When I filter, it turns into a 1 page report. I also have a button on my form that is a send to command that attaches that page of the report to an email. I can keep filtering and sending until I am done.

This answer is probably not AS efficient as the other mentioned above, but it works for me!