Search results

  1. B

    Sending Individual Reports To Individual Emails

    UGH! thanks for all the help guys - the first account i was referencing had the email missing, that's why it was blank!!! -
  2. B

    Sending Individual Reports To Individual Emails

    when i re-run it using: Debug.Print strTo instead of Debug.Print ![Eml Add1] it will run, without errors but again, the email address wont appear in the to: field, its just blank.
  3. B

    Sending Individual Reports To Individual Emails

    hmm, did i do this right? i popped it in here: Sub Mac1() Dim rsAccountNumber As DAO.Recordset Dim strTo As Variant Dim strSubject As String Dim strMessageText As String Set rsAccountNumber = CurrentDb.OpenRecordset("SELECT DISTINCT AccountNumber, [Eml Add1] FROM...
  4. B

    Sending Individual Reports To Individual Emails

    thx - i now get through that line & the PDF generates in an email to send out, but my To: line (for the recipient is blank) it should be: strTo = ![Eml Add1] - i am adding my updated code for all to see the difference that allowed me to get passed the original break: Option Compare Database...
  5. B

    Sending Individual Reports To Individual Emails

    thanks - i copy pasted your reply directly into the module but it breaks at the line with a 3061 error: too few parameters Expected 1 ...Email_Address1 is a field in my query/report but i wont need to use the other email addresses, so i would think i'd be fine from that standpoint. thx.
  6. B

    Sending Individual Reports To Individual Emails

    similar problem for a complete newbe - Please see code below that returns a run-time error 3265 due to the line: strTo = !email_address1 however, if i changed it to strTo = !AccountNumber it will populate in the outlook email To: line properly but i need the email address, not the account...
Back
Top Bottom