By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,445 Members | 3,172 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,445 IT Pros & Developers. It's quick & easy.

Prb: Mass emailing w XP Access+Outlook

P: n/a
In Access2000 mass emailing worked perfectly (very powerful tool!).
Doesn't work when using XP version of both Access and Outlook, even
though I checked the box to ensure that I was sending the email. Any
ideas?
Thanks in advance.

Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Strasser,
GRRR! Let's hope you are spamming people that wanted what you are sending.
There are a couple methods. First, creating an instance of Outlook in your
VBA code in Access. Second, using docmd.sendobject to send a message. Your
post sounds like you are using a built-in feature I am unfamiliar with. I
might be more helpful if you provided more detail.

"Strasser" <wi******************@hotmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...
In Access2000 mass emailing worked perfectly (very powerful tool!).
Doesn't work when using XP version of both Access and Outlook, even
though I checked the box to ensure that I was sending the email. Any
ideas?
Thanks in advance.

Nov 13 '05 #2

P: n/a
"Strasser" <wi******************@hotmail.com> wrote:
In Access2000 mass emailing worked perfectly (very powerful tool!).
Doesn't work when using XP version of both Access and Outlook, even
though I checked the box to ensure that I was sending the email. Any
ideas?


What's the code you are using?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 13 '05 #3

P: n/a

Tony Toews wrote:
"Strasser" <wi******************@hotmail.com> wrote:
In Access2000 mass emailing worked perfectly (very powerful tool!).
Doesn't work when using XP version of both Access and Outlook, even
though I checked the box to ensure that I was sending the email. Anyideas?


What's the code you are using?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm


Strasser's reply:
I'm not using any "code".

I'm using the following procedure (notes I wrote to myself)

An "email merge" is the email equivalent of a "mail merge".

MAIL MERGE EXPLANATION:

Example: you want to print 10 unique letters. Most of the text will be
the same in each letter.
However, for each recipient the specifics in her/his letter will be
different. The recipients' unique data is recorded in an Access
database.

#1 Access part
In the Access database you can create a query to display only those 10
recipients that will receive the letter.
For each of those recipients, you choose the fields containing the data
desired in each of the 10 letters.
If you want to do an "email merge" to each recipient, their email
address must be one of the fields in the query.

#2 Word part
Use Microsoft Word to write the text that will be common to each of the
10 letters.
This common text is the "shell" into which the correct data for each of
the 10 recipients will be inserted as each letter is printed.

#3 Merge part
Now the "shell" of text will be merged with the "data" for each
recipient.

Each "shell" is printed.
There are 10 recipients, so the "shell" is printed exactly the same in
each of the 10 letters.
What happens with each printing is that unique information is pulled
from the database for each recipient.
..
If there are 10 Access records in the query, then 10 unique letters are
printed.

A "mail merge" can be very useful.

EMAIL MERGE EXPLANATION:
Microsoft Outlook (Not Outlook Express) is necessary to do an email
merge.

Using Outlook, it is possible to choose "send to email" instead of
"send to printer" at the point where the Word "shell" document is
merged with the Access data.

(The email address must be one of the fields that is brought into each
of the merged documents. You identify that field as the email address,
so Outlook knows the email address for each merged document. If the
email address is missing, Outlook would not "know" where to send the
email.)

The result is exactly like the results of a mail merge, except the
merged documents are emailed en mass instead of printed by the printer.

So what?
The sending of the emails is done very quickly.
Approximately 65 such merged emails can be sent on a T-1 line in 1-2
seconds.
Just compare that to the time it would take to send 65 emails
individually!

The speed of sending the merged emails is dependent upon the speed of
the internet connection.

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.