Email from Access2K2 and Outlook 2007?

  • Thread starter Thread starter Jim Ory
  • Start date Start date
J

Jim Ory

Using WinXP and Access2K2

Thanks for all the help I've recieved from this group in the past.

After successfully incorporating Arvin Meyer’s VBA (Arvin Meyer
(e-mail address removed)) to email from Access2K2 through Outlook2K2, I have
found that trying to do the same, replacing Outlook2K2 with Outlook 2007, I
cannot get email output. At home, I use both Access2K2 and Outlook2K2 and
everything works quite well. When I take the program to install it at the
Charity’s office, that uses Outlook 2007, it fails. I understand there are
significant differences in the way Outlook 2007 handles spamming by not
allowing other programs to do mass emailing.

The first question is should I be looking in the Outlook discussion group or
the Access discussion group, as they are both involved? I did some looking in
the Outlook group, but most of the answers were how to turn off the warning
messages. One answer in the group concerned a CDO reference, which I did not
understand.

The second question, if there is a solution in the Access discussion group,
what can I do next to enable mass mailing from Access2K2 through Outlook 2007?

References used in my database are: Visual Basic for Applications, Microsoft
Access 10.0 Object Library, OLE Automation, & Microsoft DAO 3.6 Object
Library.

Arvin Meyers VBA: (I left out the routine to select recipients for
“strEmailâ€.)

Private Sub cmdEmail_Click()
On Error GoTo Err_cmdEmail_Click

Dim strDocName As String
Dim strEmail As String
Dim strMailSubject As String
Dim strMsg As String
Dim strRptFormat As String
Dim strTo As String ‘I added this thinking it might help

strTo = Me.txtTo & vbNullString
strEmail = Me.txtSelected & vbNullString
strMailSubject = Me.txtMailSubject & vbNullString
strMsg = Me.txtMsg & vbNullString

DoCmd.SendObject acSendNoObject, , , To:=strTo, Bcc:=strEmail,
subject:=strMailSubject, Messagetext:=strMsg

Exit_cmdEmail_Click:
Exit Sub

Err_cmdEmail_Click:
Select Case Err.Number
Case 2501 'Cancelled SendObject EMail
Case Else
MsgBox Err.Description
Resume Exit_cmdEmail_Click
End Select

End Sub


Thanks for taking the time to look at this.
 
Did you ever get an answer to this? If not, I suggest you look into the Redemption
library. Search newsgroups and/or Google for Redemption Email and you'll find
the site, the library and sample code to allow you to circumvent the warning.
 
Did you ever get an answer to this? If not, I suggest you look
into the Redemption library. Search newsgroups and/or Google for
Redemption Email and you'll find the site, the library and sample
code to allow you to circumvent the warning.
Click to expand...

For a broader view, there's also Tony Toews's Access EMail FAQ:

http://www.granite.ab.ca/access/email.htm

Surprisingly to me, Tony doesn't mention the Outlook Redemption,
which I know people around here have used successfully for many
years.
 
Hi Danny,
No I have not received any help so far. The warning message is something
like, "Access cannot send this email" or "Database cannot send emai"; I don't
remember exactly. Most of the information on this subject has not covered
using Outlook 2007, which is why I don't know if it is an Outlook problem or
an Access problem. I did find a commercial solution advertisement that claims
it can get around this problem. At $299 for the program I thought I'd see if
there was a different approach. Thanks for your response anyway.
 
HI David,
Thanks for the tip. I've been to Tony Toews site, but did not find a
reference to Outlook 2007 specifically. It may be that no one else has had
this problem, so solutions would not have been discovered. Sort of like the
rare disease syndrome, you could have it, but no one knows about it but you.
 
I've been to Tony Toews site, but did not find a
reference to Outlook 2007 specifically. It may be that no one else
has had this problem, so solutions would not have been discovered.
Sort of like the rare disease syndrome, you could have it, but no
one knows about it but you.
Click to expand...

I think a lot of professional Access developers are not using Access
2007 (I'm not and won't take on projects in A2K7). There are serious
concerns over performance and the massive UI alterations that keep a
lot of us from taking the plunge.

Of course, I'm almost always 2 to 3 years late to the party on a new
version of Access (I wait at least until the first service pack, and
generally longer). I'm just very cautious in that regard.
 
Jim Ory said:
Hi Danny,
No I have not received any help so far. The warning message is something
like, "Access cannot send this email" or "Database cannot send emai"; I
don't
remember exactly. Most of the information on this subject has not covered
using Outlook 2007, which is why I don't know if it is an Outlook problem
or
an Access problem. I did find a commercial solution advertisement that
claims
it can get around this problem. At $299 for the program I thought I'd see
if
there was a different approach. Thanks for your response anyway.
Click to expand...
 
Jim Ory said:
Hi Danny,
No I have not received any help so far. The warning message is something
like, "Access cannot send this email" or "Database cannot send emai"; I
don't
remember exactly. Most of the information on this subject has not covered
using Outlook 2007, which is why I don't know if it is an Outlook problem
or
an Access problem. I did find a commercial solution advertisement that
claims
it can get around this problem. At $299 for the program I thought I'd see
if
there was a different approach. Thanks for your response anyway.
Click to expand...
 
Jim Ory said:
Hi Danny,
No I have not received any help so far. The warning message is something
like, "Access cannot send this email" or "Database cannot send emai"; I
don't
remember exactly. Most of the information on this subject has not covered
using Outlook 2007, which is why I don't know if it is an Outlook problem
or
an Access problem. I did find a commercial solution advertisement that
claims
it can get around this problem. At $299 for the program I thought I'd see
if
there was a different approach. Thanks for your response anyway.
Click to expand...
 
pb110005-2351 said:
Jim Ory said:
Hi Danny,
No I have not received any help so far. The warning message is something
like, "Access cannot send this email" or "Database cannot send emai"; I
don't
remember exactly. Most of the information on this subject has not covered
using Outlook 2007, which is why I don't know if it is an Outlook problem
or
an Access problem. I did find a commercial solution advertisement that
claims
it can get around this problem. At $299 for the program I thought I'd see
if
there was a different approach. Thanks for your response anyway.
--
Jim Ory


Danny J. Lesandrini said:
Did you ever get an answer to this? If not, I suggest you look into the
Redemption
library. Search newsgroups and/or Google for Redemption Email and
you'll find
the site, the library and sample code to allow you to circumvent the
warning.

--
Danny J. Lesandrini
(e-mail address removed)
www.amazecreations.com


"Jim Ory" <jim[at]oryfamilyhistory[dot][comma]> wrote in ...
Using WinXP and Access2K2

Thanks for all the help I've recieved from this group in the past.

After successfully incorporating Arvin Meyer's VBA (Arvin Meyer
(e-mail address removed)) to email from Access2K2 through Outlook2K2, I
have
found that trying to do the same, replacing Outlook2K2 with Outlook
2007, I
cannot get email output. At home, I use both Access2K2 and Outlook2K2
and
everything works quite well. When I take the program to install it at
the
Charity's office, that uses Outlook 2007, it fails. I understand there
are
significant differences in the way Outlook 2007 handles spamming by
not
allowing other programs to do mass emailing.

The first question is should I be looking in the Outlook discussion
group or
the Access discussion group, as they are both involved? I did some
looking in
the Outlook group, but most of the answers were how to turn off the
warning
messages. One answer in the group concerned a CDO reference, which I
did not
understand.

The second question, if there is a solution in the Access discussion
group,
what can I do next to enable mass mailing from Access2K2 through
Outlook 2007?

References used in my database are: Visual Basic for Applications,
Microsoft
Access 10.0 Object Library, OLE Automation, & Microsoft DAO 3.6 Object
Library.

Arvin Meyers VBA: (I left out the routine to select recipients for
"strEmail".)

Private Sub cmdEmail_Click()
On Error GoTo Err_cmdEmail_Click

Dim strDocName As String
Dim strEmail As String
Dim strMailSubject As String
Dim strMsg As String
Dim strRptFormat As String
Dim strTo As String 'I added this thinking it might help

strTo = Me.txtTo & vbNullString
strEmail = Me.txtSelected & vbNullString
strMailSubject = Me.txtMailSubject & vbNullString
strMsg = Me.txtMsg & vbNullString

DoCmd.SendObject acSendNoObject, , , To:=strTo, Bcc:=strEmail,
subject:=strMailSubject, Messagetext:=strMsg

Exit_cmdEmail_Click:
Exit Sub

Err_cmdEmail_Click:
Select Case Err.Number
Case 2501 'Cancelled SendObject EMail
Case Else
MsgBox Err.Description
Resume Exit_cmdEmail_Click
End Select

End Sub


Thanks for taking the time to look at this.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top