Send mail using addresses in Access?

S

Stephen Quist

Hi,

We have a membership list in Access 2003. We'd like to send an email to all
the members that have an email address.

From Outlook 2003 I haven't found a way to use the addresses in Access.
I tried running a query, exporting it as .csv and importing it into Outlook.
This requires a non-trivial amount of cleaning up (I used Notepad) to make
all the addresses look good.
I could import the addresses into Outlook, but, once there, I could not do
anything with them such as put them into a distribution list.

Is there a way to get the email addresses in Access attached to emails in
Outlook?
The mail merge to Word produces paper or equivalent, but apparently doesn't
allow me to create emails.
There doesn't seem to be an automatic link from Access to Outlook like the
links to Word and Excel.

What are the options here?

Thanks,

Steve
 
M

Michelle Meyer

Hello Stephen:

Have you tried running a word merge document from your access list. Once you
set up your word merge document, when you go to merge - just merge to
outlook (rather than a new document or a printer). My clients do this all
the time. In the end every individual on your list will end up with an email
in the outbox of outlook after your done merging. Then you just go to
outlook and hit the send/receive button. You'll want to make sure outlook is
your default mail application.

Just email if you have any questions:
(e-mail address removed)

1stContactSignature1st Contact (Access Database Services) Email:
(e-mail address removed) Phone: (608) 437-5647 Snail Mail: 606 Valley Street
Mt. Horeb, WI 53572
 
S

Stephen Quist

Hi Michelle,

I did not try that. I did not see an option to merge to outlook when I tried
it. Where should I look for it?

Steve
 
A

Arvin Meyer [MVP]

There isn't an automatic link, but you can use code such as the code at:

http://www.datastrat.com/Download/OutlookForms2K.zip

and more specifically at:

http://www.datastrat.com/Code/OutlookEmail.txt

Here's a routine that opens a specific Outlook record from Access, but you
need to have stored the Outlook GUID string in Access, programmatically.

Private Sub cmdOutlook_Click()
Dim olApp As Object
Dim nsMAPI As NameSpace
Dim mFolder As MAPIFolder
Dim i As Integer
Dim contractor As Object
Dim EntryID As Variant

Set olApp = GetObject("", "Outlook.Application")
Set nsMAPI = olApp.GetNamespace("MAPI")
Set mFolder = nsMAPI.Folders("Public Folders").Folders("All Public
Folders").Folders("Contractors")

EntryID = DLookup("ExchangeEntryID", "tblContractor", "[ID] = '" &
Me.txtID & "'")

If Not IsNull(EntryID) Then
Set contractor = nsMAPI.GetItemFromID(EntryID, mFolder.StoreID)
contractor.Display
Else
MsgBox ("This customer is not available in the Contractors folder.")
End If
End Sub
 
S

Stephen Quist

Thanks. My skill in VBA is much closer to "novice" than "average" but I
think I can make sense of this.

Steve

Arvin Meyer said:
There isn't an automatic link, but you can use code such as the code at:

http://www.datastrat.com/Download/OutlookForms2K.zip

and more specifically at:

http://www.datastrat.com/Code/OutlookEmail.txt

Here's a routine that opens a specific Outlook record from Access, but you
need to have stored the Outlook GUID string in Access, programmatically.

Private Sub cmdOutlook_Click()
Dim olApp As Object
Dim nsMAPI As NameSpace
Dim mFolder As MAPIFolder
Dim i As Integer
Dim contractor As Object
Dim EntryID As Variant

Set olApp = GetObject("", "Outlook.Application")
Set nsMAPI = olApp.GetNamespace("MAPI")
Set mFolder = nsMAPI.Folders("Public Folders").Folders("All Public
Folders").Folders("Contractors")

EntryID = DLookup("ExchangeEntryID", "tblContractor", "[ID] = '" &
Me.txtID & "'")

If Not IsNull(EntryID) Then
Set contractor = nsMAPI.GetItemFromID(EntryID, mFolder.StoreID)
contractor.Display
Else
MsgBox ("This customer is not available in the Contractors
folder.")
End If
End Sub

--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Stephen Quist said:
Hi,

We have a membership list in Access 2003. We'd like to send an email to
all the members that have an email address.

From Outlook 2003 I haven't found a way to use the addresses in Access.
I tried running a query, exporting it as .csv and importing it into
Outlook.
This requires a non-trivial amount of cleaning up (I used Notepad) to
make all the addresses look good.
I could import the addresses into Outlook, but, once there, I could not
do anything with them such as put them into a distribution list.

Is there a way to get the email addresses in Access attached to emails in
Outlook?
The mail merge to Word produces paper or equivalent, but apparently
doesn't allow me to create emails.
There doesn't seem to be an automatic link from Access to Outlook like
the links to Word and Excel.

What are the options here?

Thanks,

Steve
Click to expand...
Click to expand...
 
M

Michelle Meyer

Stephen:

On my toolbar - the email merge button sits right next to the button used
when merging to the printer. The email merge button has a picture of an
envelope on it. I tried to copy a picture of the button into my last
response but it didn't "take".

Michelle
 
U

UpRider

Stephen,
Indeed it does. Export your query containing the email addresses to a csv
file. Exit Access.
Run Word, Tools, MailMerge wizard. One of the options is to merge to email.

HTH,
UpRider
 
D

darrin.wilson

Hi,

We have a membership list in Access 2003. We'd like to send an email to all
the members that have an email address.

From Outlook 2003 I haven't found a way to use the addresses in Access.
I tried running a query, exporting it as .csv and importing it into Outlook.
This requires a non-trivial amount of cleaning up (I used Notepad) to make
all the addresses look good.
I could import the addresses into Outlook, but, once there, I could not do
anything with them such as put them into a distribution list.

Is there a way to get the email addresses in Access attached to emails in
Outlook?
The mail merge to Word produces paper or equivalent, but apparently doesn't
allow me to create emails.
There doesn't seem to be an automatic link from Access to Outlook like the
links to Word and Excel.

What are the options here?

Thanks,

Steve
Click to expand...

Try the attached link. It pulls all of the addresses from your db and
compiles your message.
 
D

darrin.wilson

Hi,

We have a membership list in Access 2003. We'd like to send an email to all
the members that have an email address.

From Outlook 2003 I haven't found a way to use the addresses in Access.
I tried running a query, exporting it as .csv and importing it into Outlook.
This requires a non-trivial amount of cleaning up (I used Notepad) to make
all the addresses look good.
I could import the addresses into Outlook, but, once there, I could not do
anything with them such as put them into a distribution list.

Is there a way to get the email addresses in Access attached to emails in
Outlook?
The mail merge to Word produces paper or equivalent, but apparently doesn't
allow me to create emails.
There doesn't seem to be an automatic link from Access to Outlook like the
links to Word and Excel.

What are the options here?

Thanks,

Steve
Click to expand...

Forgot the link.
http://www.databasedev.co.uk/email-from-ms-access-form.html
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Emailing from Access 2
Using Access email addresses to send out an email blast 1
Access Email Addresses 5
Access and Outlook - Using email addresses from Access 7
Why don't Outlook email addresses show up in a linked Access table 1
Emails from Access 2003 Table 3
E-Mail Addresses 6
How can I put E-mail addresses from a Access file into Outlook? 2

Top