Solved

Access 2007 and Outlook

Posted on 2011-03-21
3
341 Views
Last Modified: 2012-05-11
I have a client that wants to send out mass emails from their database.  I have designed, for another client, a database that loops through a list of email addresses and sends an email one at a time out of Outlook.  I was going to modify that database for the new client, but I was thinking, is there an easier way? Couldn't I write code to blind cc the email addresses and it just send once.  There could be up to 500 email addresses.  OR could I write code to create a group and blind cc the group?  Which would work best?  Thanks for your thoughts.
0
Comment
Question by:Sasha42
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 21

Assisted Solution

by:Boyd (HiTechCoach) Trimmell, Microsoft Access MVP
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP earned 150 total points
ID: 35184953
There are limits to how many cc and bcc you can have. Most ISP's will probaly see senid a email to 500 on a bcc as spam and block and/or ban the them.

Since the is for a client I would recommend using Total Access Emailer (Click Here)
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 150 total points
ID: 35185526
Will this email be exactly the same for all recipients?
If so, you could add all the target recipients to a "Distribution list" in Outlook, then just sent the email to this group.
  File-->New-->Distribution list

(However, this will not allow for the email to be customized for each recipient.)

JeffCoachman
0
 
LVL 20

Accepted Solution

by:
darbid73 earned 200 total points
ID: 35186889
wow I just read a similar question in another forum.

It seemed that there was a limit on the number of recipients in this other question.  

If you code for one email with a very large number of recipients things could change in the future or you could run faul of your ISP's rules as HiTechCoach has said.


I think the distribution list is a good idea if you can create it.  I deal with these, a distribution list will mean that it has its own "email address" so once you have created the distribution list you send 1 email to the "email address" of the distribution list.  Then the server sends the emails to all these people.

Given that the likelihood of an ISP blocking your email with a massive number of recipients is pretty high now or in the future, AND that your client might next say he wants certain recipients to get a special email, I would stick with a loop which send individual emails.

0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question