e-mail to varible people

[rainbows]

hi.

I have a query and report that shows all "open issues " IE "active "and who those issues are assigned to.

at present I have a macro that is in the "contract details form" that sends all the open issues to that individual person. this is not what i reall want to do

what i would like to do is 2 things

1. e-mail the indiviual person all his open issue ( active )
2 when selecting a macro it would send several e-mail to all the people who have assigned "active" issue to deal with

at present i have 3 active issues with 2 people and if possible i would like to automactally send them their indivadual issue onlt


i have attached the database so that you could see what i am doing

thanks for your help

steve

 

[Ranman256]

make a form with a list box of users/emails
add a combo box of reports.
a button to send the report to the user

select the report, select the user, click Send button
the query for the report would look at the listbox to pull only the data assigned to that person:
select * from table where [user]=forms!myForm!lstUser

the send button would would send via:
docmd.SendObject acSendReport ,me.cboRpt ,acFormatPDF,me.lstUser,,,sSubj,sBody

you could also send to all users in the lstbox by cycling thru the list.

 

[arnelgp]

This is not macro but vba. I uses the 2nd send email button

 

[rainbows]

hi ,

I have a combo box with the reports in it
the report brings up all the reports with the names in it , for report "open issues " there are 2 reports for steve.kirk iD 1.AND 3 and ID 2 for mike robinson. from the query

I don't know how to do the code for the macro

thanks for your help

steve

 

[rainbows]

arnelgp


thank you . the e-mails are working but the report still includes " closed " records If there is records that are still active can we make it that it only send " active " ones and can we get each report line on one line. by trying landscape.

looking more closely could it be possible to output the report I have ? " open issues " for each person on that report ? the output would be a lot better

really appreciate your help
thanks
steve

 

[arnelgp]

Here is what i have so far. Use you report combo.

 

[rainbows]

hi,

thank you

the "closed" actions are still showing on the issue iist and all open reports

EDITED THIS

closed are now ok

but love the drop down box to select from

how can we send the automatically without me having to press send on the ones where there is more that one report to send


great help to me
steve

 

[Mark_]

how can we send the automatically without me having to press send on the ones where there is more that one report to send

Possible problem you will encounter, do you have permissions to automatically send? If you are doing this on a home machine this should be true, but on a work machine your administrator may have restricted you systems ability to automatically send.

As an example, for my work machine processes cannot automatically send through Outlook because our IT department prevents this behavior. If this for your business please verify if this will be an issue. If so, let us know.

 

[The_Doc_Man]

Mark_ is correct, but usually if your supervisor who asked for the function is willing to verify to your IT department that you have a legit need to do the auto e-mail, you can get a spot waiver. You need someone above you in the "chop chain" to get over that hump for you so that the IT guy knows that someone else knows about this - and that you are therefore not just blowing smoke.

 

[rainbows]

hi,

I will have no problems from anyone if I want to sent it automatically. the database will be put on the server. so providing there is no problems with it being on the server and with outlook and sending automatically that's what they will want

thanks steve