Sending E-mail from Access application

M

MusMou

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.
 
M

MusMou

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:
 
M

MusMou

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:
 
D

David C. Holley

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?
 
M

Michael Bauer

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?
 

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

Apple Script in Outlook 365 Mac keystrokes blocked on M1 mac 0
Sending E-mail from Access application? 9
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Mail Merge skipping records/sending one at a time 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
How do I send sounds in e-mails? 1
File in use by another application or user 2
Sending e-mails from specific email address 2

Top