Send emails from Access using runtime 2007

[toddr]

I have a MS Access 2007 app which uploads images from a number of users to a
file server. When a user uploads an image i want to generate an email
notifying someone that there is a new image in a particular folder. I want it
to be seemless to the person uploading so i don't want to use sendobject as
that causes a send window to pop up. I found code to use outlook objects in
VBA which work fine on my computer with the full version of Access 2007.
problem is when i package and distribute with Access 2007 Runtime I get an
error on the send command.

I have included references for MS Outlook 12.0 library, DAO 3.6, VBA, etc.
but it still does not work. Anyone have any ideas? forum.

Thanks,

Todd

 

[Albert D. Kallal]

Are you using late binding for the outlook code?

I don't see any reason why this would not work in the runtime edition.....

However, if the target computer has a differnt verison of outlook then yours
and you don't use late binding..then this likey is the problem...


Late binding is explained here:
http://www.granite.ab.ca/access/latebinding.htm

 

[Tony Toews [MVP]]

problem is when i package and distribute with Access 2007 Runtime I get an
error on the send command.

What is the exact error message?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/