Emailing from Access 2003 using VBA code via Outlook 2007 errors o

[Bill]

The company I work for has recently converted there previous corporate email
application to MS Outlook 2007. However, MS office 2003 is still being used
for all of the other office components. Prior to the convertion I was
developing a small MS access program that generated an email with the click
of a button. This worked fine with the previous email application(Novell
groupwise) and also with Outlook 2003. However, with the new version of
Outlook 2007 on my work PC, as soon as I click the send button from the
Access program I immediately get the Microsoft message that the Access
application has encountered a problem and must close with the option to send
an error report.

Are there any solutions to this problem? Settings, references, VBA?

I am dependent on our corporate IT department for software upgrades. Not
sure if Office 2007 is coming any time soon.

 

[mustafa mermer]

The company I work for has recently converted there previous corporate
email
application to MS Outlook 2007. However, MS office 2003 is still being
used
for all of the other office components. Prior to the convertion I was
developing a small MS access program that generated an email with the
click
of a button. This worked fine with the previous email application(Novell
groupwise) and also with Outlook 2003. However, with the new version of
Outlook 2007 on my work PC, as soon as I click the send button from the
Access program I immediately get the Microsoft message that the Access
application has encountered a problem and must close with the option to
send
an error report.

Are there any solutions to this problem? Settings, references, VBA?

I am dependent on our corporate IT department for software upgrades. Not
sure if Office 2007 is coming any time soon.

 

[Tony Toews [MVP]]

The company I work for has recently converted there previous corporate email
application to MS Outlook 2007. However, MS office 2003 is still being used
for all of the other office components. Prior to the convertion I was
developing a small MS access program that generated an email with the click
of a button. This worked fine with the previous email application(Novell
groupwise) and also with Outlook 2003. However, with the new version of
Outlook 2007 on my work PC, as soon as I click the send button from the
Access program I immediately get the Microsoft message that the Access
application has encountered a problem and must close with the option to send
an error report.

Are there any solutions to this problem? Settings, references, VBA?

Do you have a reference set to Outlook 2007 on your system rather than
Outlook 2003? Likely so as you know about references but I have to
ask.

Have you tried late binding? Which is recommended anyhow.

Late binding means you can safely remove the reference and only have
an error when the app executes lines of code in question. Rather than
erroring out while starting up the app and not allowing the users in
the app at all. Or when hitting a mid, left or trim function call.

This also is very useful when you don't know version of the external
application will reside on the target system. Or if your organization
is in the middle of moving from one version to another.

For more information including additional text and some detailed links
see the "Late Binding in Microsoft Access" page at
http://www.granite.ab.ca/access/latebinding.htm

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/