can Multiple forms to be email using the ifelse statement in the code

[annie8508]

Is there a way to email multiple forms by a primary key or using a ifelse statement in the Coding area?

Currently, I only have this form open "frmStandard"

Private Sub Email_Click()
 
DoCmd.SendObject acSendForm, "frmStandard", acFormatPDF, Me.Processor_Email, , , "Automated Message: Loan #" & Me.[Loan_Number] & " Review #" & Me.[Review_Number] & " has been reviewed", "The STANDARD Review has been completed and attached below.", True
Me.FilterOn = True
End Sub
 

I want to add another form or Multiple forms to be email to the one email only if it has the same Loan Number and Review #
Each form is based currently on different tables.

Is there a way to do this?

[zmbd]

Is there a way to do this?

Short answer, Yes.

(^-^)

Ok,you might find the article on automation interesting:
Application Automation
This covers some basics using Outlook and VBA to automate things... and this will be one of the only ways you can add multiple attachments.

There are also few different ways of sending out email, some of which have been just recently discussed... Search Return

As for the specfics of implementation, that is like chasing cats... take this one for example: http://bytes.com/topic/access/answer...acts-email-vba dealing with queries; however, the concepts should still work.

If you're still stuck let us know.