Sending personalized bulkmails

[John J.]

I'm writing a bulkmail program in MS Access in order to send personalized
mails to for instance 100 people. I've already ran into the security issue
that Outlook prompts and waits for 5 seconds per mail, so sending 100 mails
in that way would take the user tons of time. Third party software that
would take care of the security issue is not an option in this case.

So I tried a different approach: automatically saving all 100 emails in the
Concepts folder (which doesn't give the security warning). Now I would like
the user to be able to drag the 100 concept mails to the Out-folder and send
the mails in one action. However, I noticed that Outlook doesn't send those
mails automatically when you drag them to the Out-folder.

Is there some way a user can select the concept mails and send them in one
action? Any other hints.

Thank you,
John

 

[VanguardLH]

I'm writing a bulkmail program in MS Access in order to send personalized
mails to for instance 100 people. I've already ran into the security issue
that Outlook prompts and waits for 5 seconds per mail, so sending 100 mails
in that way would take the user tons of time. Third party software that
would take care of the security issue is not an option in this case.

Then Access or any other 3rd party software (that isn't itself an e-mail
program) is unusable. That also means you cannot use MapiLabs add-on
for Outlook to bypass the security prompt. I don't know if the Mail
Merge feature in Word to send e-mails through Outlook also incurs the
security prompt but I wouldn't be surprised.

So I tried a different approach: automatically saving all 100 emails in the
Concepts folder (which doesn't give the security warning). Now I would like
the user to be able to drag the 100 concept mails to the Out-folder and send
the mails in one action. However, I noticed that Outlook doesn't send those
mails automatically when you drag them to the Out-folder.

You need to programmatically submit the records to Outlook so that it
can actually build records in its message store database for sending
those e-mails. You aren't creating e-mails in Access. You are merely
creating either a mailing list of recipients and/or the body of the
message. That's not an e-mail record to Outlook.

Even if it did work, does your e-mail provider let you submit outbound
e-mails where 100 recipients are listed?

Is there some way a user can select the concept mails and send them in one
action? Any other hints.

Use Access, Excel, or whatever to build a list of recipients. Put the
content of the e-mail in a file. Then use a bulk mailing program that
reads both files to send out a copy of your e-mail to each recipient.
Google for bulk mail programs. I think slipstick.com lists some.

It sounds like you really need to investigate using a bulk mail program
or employ a listserver.

 

[John J.]

Thanks Vanguard,

See inline:

You need to programmatically submit the records to Outlook so that it
can actually build records in its message store database for sending
those e-mails. You aren't creating e-mails in Access. You are merely
creating either a mailing list of recipients and/or the body of the
message. That's not an e-mail record to Outlook.

OK, but those unsent Outlook mails do look just like 'real' mails. When I
open them, in the message window it says 'This message has not been sent'. I
can then manually send them one by one. I'm quite astouned that if you have
10 draft mails you can't even send them at once from within Outlook.

Even if it did work, does your e-mail provider let you submit outbound
e-mails where 100 recipients are listed?

It will sent an email with more than 100 recipients. I'm not sure if it will
send 100 different emails at once, but I will check that.

Use Access, Excel, or whatever to build a list of recipients. Put the
content of the e-mail in a file. Then use a bulk mailing program that
reads both files to send out a copy of your e-mail to each recipient.
Google for bulk mail programs. I think slipstick.com lists some.

Making a recipient list in Access is easy but my goal is to make
personalized emails in a way that the content really differs from eachother.
Not only the recipients name and his/her first name but also for instance
the stock items or properties. It's al ready, only I can't send them :-(

I will check the bulk mail programs, only little change the IT people will
agree.

John

 

[VanguardLH]

I will check the bulk mail programs, only little change the IT people will
agree.

I would think that if you are allowed to install a bulk mailing program
then they would also permit you to install an add-on to Outlook,
especially one from MapiLabs as that is a well-known and reputable
software vendor.

http://www.mapilab.com/outlook/security/
"Advanced Security for Outlook is free for commercial and non-commercial
use."

That seems to be your original problem of the security prompt when
trying to use macros in Access which then has Access trying to submit
records to Outlook to send them as e-mails.

 

[Diane Poremsky [MVP]]

Mail merge from word does not trigger the prompt provided you use HTML
message format.

--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/



Exchange Messaging Outlook newsletter:
(e-mail address removed)




You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.