Using Access to generate email

[srctr]

I would like to Add to my Switchboard an item that when clicked will
automatically open an email with all email addresses in the BCC field, fill
in the subject line and body of the message. I would then add my attachment.
I have a field that I used to create a query that would only pull records
that have a yes for Newsletter by Email. I have looked at all the comments
in this discussion but can't seem to figure out what to do. I tried creating
a Macro and a command button on a form. But neither fills in the TO or BCC
field.

So I don't know if I need a report, form or macro to accomplish this. Have
limited knowledge of Access.

 

[srctr]

Isn't there anyone who can help me with this. I just need to know how to set
up the ability to click on a button that would Open Outlook, fill in all
email addresses that have a Yes in a field to send Newsletter by Email
puttting the email addresses in the BCC field, fill in the subject, fill in
the message box and then allow me to attach a file manaully and send.

HELP!

 

[Ceedy]

I've had the same problem. You can do it in Access but are limited to 256
characters which didn't work for me. A friend recommended a program called
Gammadyne Mailer. I tried it and it reads from my Access program great.
It'll take a little time to figure it out (at least it did for me) but for
around $150, it sure made my life easier. And no. I do not work for the
company.

 

[srctr]

I don't want to buy a program. We are a Non-profit. I need to use the
programs I have. There must be an easy way to create a button, a query, a
form or whatever that will grab all the email addresses and create the email
message. I don't mind filling in the message and attaching the file. I just
all the emails in a table that meet the query to create an email to be sent
from Outlook