G
Guest
Hello -
I have a membership database. I've created a member directory and
automated, via command button, printing of this report to a PDF document so
it can be emailed to all members who have an email address in the database.
I've created a query to extract the email addresses if not null (not every
member has email).
I have a form with a command button and when clicked I want the default
email program (Outlook Express) to open, have ALL email addresses
automatically entered into the TO field, allow the user to edit the email,
then attach the PDF docuemnt, and send the same report to ALL users at once -
not one email at a time.
When I use the SendObject macro, I only get one email printed in the TO
field of Outlook. Is there a way for every email in the database to be
automatically inserted rather than cutting and pasting from the table?
Thanks for the help!
I have a membership database. I've created a member directory and
automated, via command button, printing of this report to a PDF document so
it can be emailed to all members who have an email address in the database.
I've created a query to extract the email addresses if not null (not every
member has email).
I have a form with a command button and when clicked I want the default
email program (Outlook Express) to open, have ALL email addresses
automatically entered into the TO field, allow the user to edit the email,
then attach the PDF docuemnt, and send the same report to ALL users at once -
not one email at a time.
When I use the SendObject macro, I only get one email printed in the TO
field of Outlook. Is there a way for every email in the database to be
automatically inserted rather than cutting and pasting from the table?
Thanks for the help!