Search results

  1. A

    Sending Multiple Emails from Access

    Oooo, I didn't know about CDO - Looks interesting! I'm off to do some reading.
  2. A

    Form Filter won't clear

    No they were just two different options I've tried from a Google Search Sorry the Forum stripped all my formating??
  3. A

    Sending Multiple Emails from Access

    Yep I'm using BCC - One concern though is that this still transfers all these emails from the Database to Outlook/gmail depending on how Mailto: is set up. So the Admin staff sending the emails still now has the complete list of emails from the original email. which could be a Data Protection...
  4. A

    Form Filter won't clear

    So I use this code below to call up a Contacts Form and by filter!! But the once in Form_Contacts, I can't clear the filter using a macro or VBA to search (using a ComboBox) for another contact. I've tried Private Sub Search_Contact_BeforeUpdate(Cancel As Integer) Me.Filter =...
  5. A

    Sending Multiple Emails from Access

    Thank you so much guys - went with Mailto: with a long string of emails. Seems to be working!!
  6. A

    Sending Multiple Emails from Access

    My previously Contact DB in Access xp (haha) is used mailto: BUT the string length restricted it from sending more than 200 ish chrs of Email Addresses: So I ended up creating 3 - 4 emails with a batch of email addresses in each one. Our admin then had to copy the email text to each email. My...
  7. A

    FindFirst - What am I doing wrong?

    Ah yes - thank you for your welcome and answer!! thank makes so much sense now!!
  8. A

    FindFirst - What am I doing wrong?

    Set rstGroups = dbs.OpenRecordset(Name:="Group_T", Type:=RecordsetTypeEnum.dbOpenDynaset) MsgBox Me.Group ' This shows 340 on the screen which is the group i want from rstGroups rstGroups.FindFirst "GrpID = Me.Group" ' But this line finds the first group in the...
Top Bottom