Re: Emailing with Access

marjbell@xxxxxxxxx wrote:
I have a Access database of email addresses that I would like to mass
email to customers. Can Access be used through Outlook? or can it just
be done with Access? I know it is possible to use MailMerge for
snailMail.

I had a problem running VB and creating reports, so what I did was to create a form with the information I wanted on it. I would display all but the e-mail address. I would have one button that would allow me to fire off the e-mails. The code would do:

- set the button to invisible.
- go to the first record in the set (use a DoCmd for this)
- use another DoCmd to send the e-mail to the person in the email address. Send as a Snapshot.
- Use another docmd to go to the next record
- check to see if the e-mail adress is NULL (if so, stop the program)
then go to the first line again.

That would limit your coding.

The other option is to make a report that selects only one record from the query. You could have a form that fires the code

' get the current record
' run a docmd to run the report,with the option to SendTo and where clause
' move to the next record (again with a do cmd)
' wash, rinse, repeat...

If you don't want to dirty your hands with code, then I think you are out of luck. You could drop down a level and use macros, but code is cleaner, and you can debug it while running.

Be sure to be liberal with the DoEvents otherwise you will hang your system and flood some unsuspecting schmuck with a bunch of e-mail.
Open a few accounts on mail.google.com and mail to them to see how it comes out.
.

Quantcast