Search results

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

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.

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...

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...

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.

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...