I have created a macro using the SendObject Action. I have about 30 people to email (using Outlook) a report to – so I tried to use a distribution list created in Outlook instead of typing 30 email addresses. I got an error “Unknown message recipient(s) – message was not sent”. I just left the TO: blank and can manually select the distribution list. My question is – Can you use the SendObject Action with a distribution list??
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Emailing Access Report 1
- Thread starter elaineva
- Start date
-
1
- #2
I don't think you can but you should be able to loop through the distribution list with VBA code and create a string of all the email addresses.
i.e. "Bob@aol.com;Sally@hotmail.com;Jerry@comcast.net"
And then use that string in the To: parameter of the SendObject command.
Good luck.
Bob Scriver
i.e. "Bob@aol.com;Sally@hotmail.com;Jerry@comcast.net"
And then use that string in the To: parameter of the SendObject command.
Good luck.
Bob Scriver
- Status
Similar threads
- Locked
- Question
- Locked
- Question
