Search results

  1. P

    Sending Email Via Modules

    I am trying to send a global e-mail via a module. I can get it to send with a Loop, however I have an attachment that I want to send to my entire e-mail listing (of members, this is NOT spam! I just don't want the rest of the folks to have to scroll through a bunch of e-mail addresses). If I...
  2. P

    TYPE MISMATCH ERROR AGAIN!

    I posted a couple of days ago on the Type Mismatch error. I am getting the same error in almost every function I write using SET. Does anyone have any ideas? My function is below. Option Compare Database Option Explicit Dim db As Database Dim RstTmp As Recordset Dim Loop1 As Variant Dim...
  3. P

    Type mismatch (Error 13)

    I am getting a type mismatch (Error 13) due to the following funciton. Can anyone enlighten me? Thanks in advance! Public Function RandomValue() As Integer Dim RndRecord As String Dim rst As Recordset Set rst = CurrentDb.OpenRecordset("tableteams") RndRecord = Int((rst.RecordCount * Rnd) + 1)...
Back
Top Bottom