Hope I can make clear what I like to do:
I have a company in Germany for which I have entered all e-mailaddresses in a table. Table consists of two fields: Name + e-mailaddresses
In a form I have a button to send mail in which I used to have all the e-mailaddresses listed for the German company. Now I would like to enter the name from above table to send to all these recipients.
The advantage is that the users of the database can change or add addresses themselves.
Below is what I tried but failed to work. Any ideas??
Private Sub Command4_Click()
DoCmd.SendObject acReport, "Query2", acFormatXLS, "Germany", "", "", "Sales report", "see attached document", False, ""
End Sub
I have a company in Germany for which I have entered all e-mailaddresses in a table. Table consists of two fields: Name + e-mailaddresses
In a form I have a button to send mail in which I used to have all the e-mailaddresses listed for the German company. Now I would like to enter the name from above table to send to all these recipients.
The advantage is that the users of the database can change or add addresses themselves.
Below is what I tried but failed to work. Any ideas??
Private Sub Command4_Click()
DoCmd.SendObject acReport, "Query2", acFormatXLS, "Germany", "", "", "Sales report", "see attached document", False, ""
End Sub
