Problems sending email from form to outlook

[KAquestions]

Hi all,

I am working with a database created by 1 person, maintained by another
(neither of whom used even a little vba so it's macro's everywhere) and
taken over by me to sort the whole mess out!

One problem i have is a macro which sends an email on click of a button.
This works fine for half of our users, but the other half - who got new pc's
recently, get error messages and it won't work for them.

There are 2 error messages - unfortuantely the 1st one comes up on the
screen so quickly you can't read it so don't know what it says. The second
one says

"Database can't send this email message. Before attempting to send an email
message from the Database, resolve the problem identified in the previous
meeage, or configure your computer to send and receive email messages"

I have googled all morning trying to find out how to adjust whatever
settings i need to in order that we can fix this problem but had no luck, so
am hoping someone might be able to offer some suggestions!

Thanks,

Kirst

 

[Philip Herlihy]

Hi all,

I am working with a database created by 1 person, maintained by another
(neither of whom used even a little vba so it's macro's everywhere) and
taken over by me to sort the whole mess out!

One problem i have is a macro which sends an email on click of a button.
This works fine for half of our users, but the other half - who got new pc's
recently, get error messages and it won't work for them.

There are 2 error messages - unfortuantely the 1st one comes up on the
screen so quickly you can't read it so don't know what it says. The second
one says

"Database can't send this email message. Before attempting to send an email
message from the Database, resolve the problem identified in the previous
meeage, or configure your computer to send and receive email messages"

I have googled all morning trying to find out how to adjust whatever
settings i need to in order that we can fix this problem but had no luck, so
am hoping someone might be able to offer some suggestions!

Thanks,

Kirst

This isn't an Outlook issue (unless the database is using Outlook
somehow to send messages). Sounds like there's a configuration setting
in the database (smtp?) which doesn't take account of the new
environment, but I guess you'll need someone to fix it at that level.
Your best bet is to identify the database technology used (e.g. Access)
and ask in a relevant forum. Note too that Vista is a much more
demanding environment for a developer, as the security features won't be
ignored. If you do re-post, you'll need to supply much more information
about the various software being used.

You should probably also manage expectations around you - when a
business commissions poor-quality software without proper documentation
or support then it is usually very expensive to deal with issues like
this, and even experts can take a very long time to unscramble inexpert
code. In fact, much of what makes a developer an expert is building in
understandability.

Phil, London

 

[KAquestions]

Hi Philip,

Thanks for the quick response!

It is an Access database, which is using the SendObject macro command to
send an object through Outlook.

Our users are using Outlook and Access 2002 - but some users it works for
and some it doesn't.

Kirstie

 

[KAquestions]

I have just found out that the users who have problems with this have SP3,
while the users who can use it with no problems have SP2.

Does anyone have any suggestions?

Kirstie