Sending E-mail from Access application

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My Access application does not send the E-mail witch it shoud I do not get
any Error message witch means that there is no error in the code I have
intalled the IIS and still does not work.
I do not know what I´m missing?
Is there any check list for such task?
Thanks for any help.
 
Dim iMsg As Object
Dim iConf As Object
Dim iBP
Set iMsg = CreateObject("CDO.Message")
Set iConf = CreateObject("CDO.Configuration")
With iMsg
Set .Configuration = iConf

.To = To__
.CC = CC__
.From = From__
.Subject = Subject__

.HTMLBody = "<html>test</html>"

If Me!CreateInvoiceJournal.Value = True Then
Set iBP = iMsg.AddAttachment(InvoiceJournal__)
End If
Set iBP = iMsg.AddAttachment(InvoiceFile__)
.Send
End With

Set iBP = Nothing
Set iMsg = Nothing
Set iConf = Nothing

To__, CC__, From__, Subject__, InvoiceJournal__, InvoiceFile__ are fields
from
a Form

"Michael Bauer" skrev:
 
Here is the code it works in some machines and not in some.
I do not know what I´m missing!

Dim iMsg As Object
Dim iConf As Object
Dim iBP
Set iMsg = CreateObject("CDO.Message")
Set iConf = CreateObject("CDO.Configuration")
With iMsg
Set .Configuration = iConf

.To = To__
.CC = CC__
.From = From__
.Subject = Subject__

.HTMLBody = "<html>test</html>"

If Me!CreateInvoiceJournal.Value = True Then
Set iBP = iMsg.AddAttachment(InvoiceJournal__)
End If
Set iBP = iMsg.AddAttachment(InvoiceFile__)
.Send
End With

Set iBP = Nothing
Set iMsg = Nothing
Set iConf = Nothing

To__, CC__, From__, Subject__, InvoiceJournal__, InvoiceFile__ are fields
from a Form



"David C. Holley" skrev:
 
The fact that it works on some machines and not others, helps to clarify
things. Do all of the machines have Outlook installed? How are
determining that it does not work on the machines - does it error out?
does it hang? does it run and do nothing?
 
Am Mon, 24 Oct 2005 11:15:08 -0700 schrieb MusMou:

You´re using the CDOSYS library, which I don´t know. Maybe the configuration
object must be configured?
 
Back
Top