i have a bit of an annoying one. i am fine with setting up transferspreadsheet/ sendobject type actions however this one goes a little bit further and i need some help.
At present i have a query "qrymainform" that brings together fields from 2 tables "tblFactorScores" (fields - SU_ID, Title, Score) and "TblSU" (Fields - SU_ID, SUName, EmailAdd). at present i can filter the query based on the name of the SU, and then either export it, or email it (although i have to manually select the name of the person im sending it to).
What i want to do is develop this further and automate a process that will email the relevant details to the address stored in the EmailAdd field on "TblSU". So all of unit 1's are emailed to person 1, Unit 2's are emailed to Person 2 and so on. I want to set it so that the file is in excel format when it is emailed. I dont want to hard code this in case the name of the SU changes, or the person the file needs to be email to.
Do i need to reference the query im using or the field that it needs to cycle through, and if i need to specify that where would i set it up, combo box on the same form as the combo button, specify field on the query etc?
Im still working on getting to grips with the theory on how these type of things work.
The one thing I don't like about that sample is that it's a bit of overkill with the status box and such. Not that they're not handy, but they confuse the real issue of looping the recordset and sending the email.