Connecting Tech Pros Worldwide Help | Site Map

Access2003 VBA code to e-mail being blocked to port 25

 
LinkBack Thread Tools Search this Thread
  #1  
Old January 23rd, 2006, 03:45 PM
Jim
Guest
 
Posts: n/a
Default Access2003 VBA code to e-mail being blocked to port 25

Tried a search, but didn't find quite what I was looking for.

Situation:
Have a VBA code process, tapping CDOSYS to send e-mail from Access,
attaching an Excel spreadsheet, to a given list of e-mail addresses.
Process used to work flawlessly. Now, corporate IT has upgraded the
desktop anti-virus engines to McAfee 8.0i, which is blocking attempts
at Port 25.

If I turn off the port blocking, the process works as expected. IT is
not going to allow me to turn off the port blocking each time, however.
There is, however, a section for listed excpetions, using executable
names.

Question: Using CDOSYS from A2003, what would be the EXECUTABLE name
that I could provide to the exception list. I've tried MSACCESS.EXE,
and our e-mail client (GRPWISE.EXE) to no avail.

Any suggestions would be greatly appreciated!

Code snippet responsible for sending message:

Dim iMsg As Object
Dim iConf As Object

Set iMsg = CreateObject("CDO.Message")
Set iConf = CreateObject("CDO.Configuration")
Set Flds = iConf.Fields

With iMsg
Set .configuration = iConf
.To = rs.Fields(2).Value
.CC = ""
.BCC = ""
.From = "SENDER@CORP.com"
.Subject = "Late DSD Issues"
.TextBody = strMsg 'supplied elsewhere
.addattachment strWkbName 'supplied elsewhere
.send <-- ERROR
End With


  #2  
Old January 24th, 2006, 01:55 AM
salad
Guest
 
Posts: n/a
Default Re: Access2003 VBA code to e-mail being blocked to port 25

Jim wrote:
[color=blue]
> Tried a search, but didn't find quite what I was looking for.
>
> Situation:
> Have a VBA code process, tapping CDOSYS to send e-mail from Access,
> attaching an Excel spreadsheet, to a given list of e-mail addresses.
> Process used to work flawlessly. Now, corporate IT has upgraded the
> desktop anti-virus engines to McAfee 8.0i, which is blocking attempts
> at Port 25.
>
> If I turn off the port blocking, the process works as expected. IT is
> not going to allow me to turn off the port blocking each time, however.
> There is, however, a section for listed excpetions, using executable
> names.
>
> Question: Using CDOSYS from A2003, what would be the EXECUTABLE name
> that I could provide to the exception list. I've tried MSACCESS.EXE,
> and our e-mail client (GRPWISE.EXE) to no avail.
>
> Any suggestions would be greatly appreciated![/color]

I don't have McAfee, nor do I use CDosys, but I do use
GroupWiseCommander for sending my emails via Groupwise. I can send
attachments etc and it basically uses code similar to yours below and
acts like SendObject.

Is there any difference between your code working with Groupwise open
and groupwise closed at the workstation?

[color=blue]
>
> Code snippet responsible for sending message:
>
> Dim iMsg As Object
> Dim iConf As Object
>
> Set iMsg = CreateObject("CDO.Message")
> Set iConf = CreateObject("CDO.Configuration")
> Set Flds = iConf.Fields
>
> With iMsg
> Set .configuration = iConf
> .To = rs.Fields(2).Value
> .CC = ""
> .BCC = ""
> .From = "SENDER@CORP.com"
> .Subject = "Late DSD Issues"
> .TextBody = strMsg 'supplied elsewhere
> .addattachment strWkbName 'supplied elsewhere
> .send <-- ERROR
> End With
>[/color]
  #3  
Old January 24th, 2006, 01:35 PM
Jim
Guest
 
Posts: n/a
Default Re: Access2003 VBA code to e-mail being blocked to port 25

Salad,

Makes no difference if GroupWise is open or closed. It's not
GroupWise that's the issue, though. I was just wondering if somebody
had found a way through this issue. Would you tell me more about
GroupWiseCommander? Send via e-mail, so we won't clutter the list.

Also, I've tried excluding MAPISP32.EXE, and that does not work
either.

Thanks for all the eyes on this. I do appreciate it!
-J

 

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Popular Articles

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 220,840 network members.