Help sending email from Access 2003 with external attachments 2

[BrooksR]

Trying to find a reliable method to do this.

1. SendObject will not work with external files and supposedly is not reliable after A97.

2. Have been trying CDO samples without luck. Got error:
"the SendUsing configuration is invalid"
then tried a sample which included:
objMessage.Configuration.Fields.Item("

http://schemas.microsoft.com/cdo/configuration/sendusing")

= 2
objMessage.Configuration.Fields.Item("

http://schemas.microsoft.com/cdo/configuration/smtpserver")

= "email IP"
objMessage.Configuration.Fields.Item("

http://schemas.microsoft.com/cdo/configuration/smtpserverport")

= 25
objMessage.Configuration.Fields.Update

and got the error: ""the transport failed to connect to the server"
Does CDO require Exchange Server? I don't have Exchange on my PC. CDO would be fine if it can be made to work.

3. Would Outlook 2003 be a good option? What reference do I need to set for the object Outlook.Application?

Any ideas or suggestions appreciated!

 

[Remou]

You need to install CDO (or RDO) in some way or another.

http://www.paulsadowski.com/WSH/cdo.htm

http://www.tek-tips.com/viewthread.cfm?qid=1458348&page=10

You will get info on Outlook here:

http://www.tek-tips.com/faqs.cfm?fid=2823

 

[PHV]

You have to replace 'email IP' with the IP address of your smtp server.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[BrooksR]

Thanks, Remou. CDO is installed. I get no errors when referring to the CDO objects.

For the Outlook code, what reference do I need to set for Outlook.Application to work?

Brooks

 

[BrooksR]

PH, THANKS!!!

That did it.

CDO was already on my machine.

Where does CDO come from? Windows XP? Office 2003?

Where do I install it from if my end users don't have it?

Brooks

 

[Remou]

I think this provides the answers to your questions:

http://support.microsoft.com/kb/171440/en-us