VBA Solutions for email without knowledge of email program

[dragofly]

I am developing a database to be installed on computers used by let's say unsofisticated users who work for any of 20 some odd companies. They need to send an email back with a generated multi-sheet excel spreadsheet that I create through access. From all the MAPI and CDO posts I have seen my libraries don't have those objects or methods or I get the send using configuration value is invalid error. I do not know that they all have outlook and the .send method seems to just leave the message in the outbox anyway, making us rely on the user to hit send and receive. Which though simple might be too hard for these people. So I need some suggestions and if they rely on CDO or MAPI then I need a link to where I can download the library and how to register it. I am using access 2003 from an office enterprise edition.

Thank you in advance
Shannon

 

[dbDamo]

See my post (#10) in this thread:- http://www.access-programmers.co.uk/forums/showthread.php?p=923411#post923411

To install CDO, go to Start>Settings>Control Panel>Add or Remove programs. With "Change or Remove Programs" selected, scroll down the list of currently installed programs, highlight Microsoft Office and press "Change" - this opens up Microsoft Office Setup.

Select the "Add or Remove features" radio button and press "Next".

Press the + button next to Microsoft Outlook

Click on the drop down list next to "Collaboration Data Objects" and select "Run all from My Computer".

Press Update - this installs CDO.

Make sure to set your references after

 

[dragofly]

I see that your post answers the question of why it tells me the send using setting is incorrect. And thank you very much. I now how have a little more knowledge under my belt, however, the 24 different companies do not share the same smtp server nor would it be feasible to ask all of them nor do I believe I want to walk 24 different people or more through how to enter it provided they are all using smtp and not exchange (which I think is a different protocol which in turn must use smtp to communicate with the rest of the world). I was hoping that sense they ad to put their configuration into whatever email program they are using someone would have left a way for me to either ask that program, whatever it may be without knowing what it is, to send the message (which I think would be the whole purpose of MAPI) or to get the mail configuration so I could do it myself. Now I have tried other MAPI code I have seen but even though I have everything in Office 2003 Enterprise Edition set to run off my hard drive I do not find it under References. Though when checking the CDO library under references I can now make some MAPI.insert object here objects. I don't have any help files and don't have the objects these other MAPI source codes talk about.

Thank you for reading.

 

[dbDamo]

Try this:- http://vbcity.com/forums/p/1506/7841.aspx

 

[dragofly]

Sorry for the late reply dbDamo, but they haven't let me come back to this problem for a while. The mailto works fine with the exception of not allowing for attachments.