Search results

Okay, here's what I'm trying to accomplish. I have a main form which I want to use as the recordset for an on click event to send emails. The main form includes a field called message that will be used as the message text on an email. The email addresses for each respective record are...

Good Friday, All... I have a form who's recordset is a make-table query. Fields include Group No. and Level. Is it possible to add a multi-select list or combo box rather than a subform to identify those employees matching the Group No. and Level on the main form? I'm hoping that as...

Hey, Hayley;) I figured out the code so that it at least pulls in the correct body text...here it is Private Sub CmdEmail_Click() Dim appOutl As Object Dim MyNameSpace As Object Dim myemail As Object Dim rsEmail As DAO.Recordset Dim strEmail As String Dim strBody As String Set appOutl =...

Thanx, Hayley... This issue is driving me crazy. FYI, the following code generates an email for each record in the recordset, gives me the message that notices have been sent, and then opens a blank new message in html and uses the default stationery set in Outlook. Private Sub...

Sorry...Another Post Hey, Hayley... Thought I'd let you know that the code I sent you does appear to work. I thought it was only generating one email but, once you send or save the email that comes up first, the next one appears, and so on until it loops through all records. The problem I'm...

Access 97 Thank you so much Hayley... I'm using Access 97. I'll look forward to hearing from you tomorrow. Have a great evening. ;)

Hi again, Hayley... I'm still thinking through this and am wondering if this might work. If I set my query recordset in Groupby mode and have the email address field of the query semi-colon delinated so that all addresses are identified in a single field based on their group identity, it would...

Hi, Haley... Still having some problems with this. Below is the code I used for the CmdEmail_Click event. When I click to send notices, it only creates one email although there are actually four records. Any idea what I'm doing wrong? Also, is there a way to have it just send to my Outlook...

Hi, Access Experts... I have a form that is populated from a query. This form has both an email address [email] field and a memo [body] field. I want to be able to click a button on the form and have it send individual emails to my Outlook outbox for each record within the query recordset...

Thanx so much Rich...it worked great and you saved the day! You guys/gals are really the best!;)

I have several forms within my Access 97 application that use an unbound combo box to find a record on the form. I keep getting the following error... "Compile error: Method or data member not found" (referring to Set rs = Me.Recordset.Clone) The problem appears to be at .Recordset I found...