Sending email through Outlook from within Access

[Dean B.]

Hello,

I hope you can help me.

I send out a monthly newsletter to all members in our Access database
having email, about 75 in all. Due to the anti-spam restrictions by
some email providers, I am forced to send them one-by-one. I have
created a VB module in Access (XP) to do this with my Roadrunner email
account using the Outlook (XP) object. (I also use Outlook as my
daily email application.) However, I get the "another application ...
wait 5 seconds" dialog box for each one it sends out. I also use
basic search and replace to populate fields within the message
template in order to personalize each message (i.e. Dear '<FirstName>'
and 'Your dues are paid through <year>', 'The meeting is on Tuesday,
<4thTuesday>'.

I had tried Word (XP) with mail merge to do this, but it also has the
"5 second wait". Add to that its inability to use merge fields in the
subject line, and the inability to automatically calculate the date of
the fourth Tuesday of the month, forced me to do it all from within
Access.

1. Does Outlook 2003 do away with this dialog box, or provide some
way to allow a certain app to use it without the dialog box? If so,
does Outlook 2003 allow for merge fields in the subject box?

2. Is there a better way to do this, given the parameters of a remote
SMTP/POP system and staying within the realm of existing or upgrading
components? I am a VB programmer, but have not done any email
projects outside of the aformentioned Access project. I don't mind
upgrading Office, but I don't want to HAVE to spend other money just
to help me do this volunteer job.

Thanks in advance for your help and advice.

Sincerely,

Dean

 

[Milly Staples [MVP - Outlook]]

The best method for sending personalized mail remains using mail merge. You
can also use a utility called Click Yes! to automatically okay the mail
sending from Outlook. Use google.com to search for the utility.

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. Due to the
Swen virus, all e-mails sent to my actual account will be deleted w/out
reading.

After searching google.groups.com and finding no answer
Dean B. <[email protected]> asked:

| Hello,
|
| I hope you can help me.
|
| I send out a monthly newsletter to all members in our Access database
| having email, about 75 in all. Due to the anti-spam restrictions by
| some email providers, I am forced to send them one-by-one. I have
| created a VB module in Access (XP) to do this with my Roadrunner email
| account using the Outlook (XP) object. (I also use Outlook as my
| daily email application.) However, I get the "another application ...
| wait 5 seconds" dialog box for each one it sends out. I also use
| basic search and replace to populate fields within the message
| template in order to personalize each message (i.e. Dear '<FirstName>'
| and 'Your dues are paid through <year>', 'The meeting is on Tuesday,
| <4thTuesday>'.
|
| I had tried Word (XP) with mail merge to do this, but it also has the
| "5 second wait". Add to that its inability to use merge fields in the
| subject line, and the inability to automatically calculate the date of
| the fourth Tuesday of the month, forced me to do it all from within
| Access.
|
| 1. Does Outlook 2003 do away with this dialog box, or provide some
| way to allow a certain app to use it without the dialog box? If so,
| does Outlook 2003 allow for merge fields in the subject box?
|
| 2. Is there a better way to do this, given the parameters of a remote
| SMTP/POP system and staying within the realm of existing or upgrading
| components? I am a VB programmer, but have not done any email
| projects outside of the aformentioned Access project. I don't mind
| upgrading Office, but I don't want to HAVE to spend other money just
| to help me do this volunteer job.
|
| Thanks in advance for your help and advice.
|
| Sincerely,
|
| Dean

 

[Dean B.]

Thanks, Milly, for your response. Just two more questions:

1) Does Outlook 2003 address any of these issues?

2) When email merging from within Word XP, why do I get the dialog
box which gives you the option of allowing it to send for X number of
minutes, but not from VB?

Thank you again for your help.