Search results

Looping through the record set?

Awesome Ken!!! Thank you!!!! One last question. It only sends the email to the individual who's record I have opened at the time. Is it possible to set it to send an email to everyone in that has come up in that query?

How do I fit that into my current setup?

I need the To: box to be automatically filled with the email address from a certain query. I have a query named "qryemail" that has records for individuals that have gone past a certain date, each record has an email address in a field called "customeremailaddress". I want a sendobject email...

I'm not sure what you mean, I used a table to create field 2, then placed it on a form.

Help. Bump, can anyone help me out? Can it even be done?

Awesome!!! Thank you for the help. One last question now that I have that fixed. I would like the date field that turns red when the current date is older to turn back to white when a completion date is put in another field. Here are three fields: Field 1: Return Date Field 2: 90 Days...

I have two date fields, I have it set so that when you place a date in the first field, the second field will automatically set a date 90 days after. What I need is for the second field to change red when it has been surpassed by the current date. Thank you.

I have a table/form that has name, a specific date, and an email address. I would like that when the specified date matches the current date, it will automatically send an email to the address specified with a pre-built message. Is this possible? If so, how? Thank you.