Send mail using addresses in Access?

[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

 

[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

 

[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

 

[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

 

[Stephen Quist]

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

Steve

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

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

 

[Stephen Quist]

Thanks. I will look for it.

Steve

Look for the following tool on your wordmerge toolbar:

 

[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

 

[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

 

[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

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

 

[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

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