Hi...
I am hoping someone can help me...
I have a subform which contains several records. One of the fields on the subform is "Email Address"
I created a command button on the main form to generate an email.
When I click on the command button, an email gets generated for the 1st record on the subform.
I am looking to have an individual email generated for each of the records on the subform. (There will be a maximum of 7 records).
Any help would be greatly appreciated.
This the code I am using:
if not isnull(forms![IssueInfo]![CallDetail].form![EMAIL ADDRESS] Then
DoCmd.SendObject _
, _
, _
, _
[EMAIL ADDRESS], _
, _
, _
"Re: " & [ISSUE DESCRIPTION], _
"Email Message Here", _
False