473,320 Members | 2,161 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Prb: Mass emailing w XP Access+Outlook

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
3 2322
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
"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

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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Paul | last post by:
I am using a windows service which accesses Microsoft Outlook. Outlook is supposed to send an email. This works fine when not run in a windows service. I am running the service under my user...
1
by: Iain Miller | last post by:
Currently using & developing a new application in A97. This app has a lot of Name & Address information in it. A lot of that information will be duplicated in Outlook & I suddenly wondered if its...
2
by: Bob | last post by:
Hi Everybody A tough one!!! Is there any way that incoming eMails (MailItems) into Ms Outlook can be used to automatically create records in a ms Access table or sub table. Smiley Bob
3
by: pnp | last post by:
Is there a way to access through a C#.NET app my Microsoft Outlook contacts database? Mostly for queyring information about phone numbers... Thanks in advance, Peter.
6
by: TomislaW | last post by:
Is it possible to access outlook expres mail, with dot net?
1
by: mrdata030 | last post by:
Hello, I am new to this forum so please excuse my ignorance. I am trying to import my email from outlook 2002 to ms access 2002. Everything works fine except for attachments. If outlook has an...
2
by: obroie | last post by:
Hi all, I am trying to move emails from Outlook into an Access table, the code below worked for me before, but now I am having a problem as this error message comes up: Run-time error 438 'Object...
2
by: =?Utf-8?B?VmlkZHM=?= | last post by:
Hi All, Could anyone please help me regarding this issue.I need to access or Import Outlook Contact Details from my Asp.Net web application my code behind is c#. Thanks in advance. Regards,...
0
by: spoorthisri | last post by:
Hi All, Please how to access outlook express in C#.NET. I need to read the attachment from outlook express in C#.NET. and delete the mails move the mails from outlook express. Regards,...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.