Sending an email from a Macro Problem

[Pascoe via AccessMonster.com]

Hi folks,

Been using a small macro from within a form for the last year, and today it
stopped working. Microsoft did update our computers over night....?

I am getting a 2950 error. "You tried to run a macro or use a method to carry
out an action, but an expression evaluated to the wrong data type."

Macro sends an email from the information on the Form. My Macro arguments
look like this:

, , , =[Forms].[Tenant Information].[Email address], , , =[Forms].[Tenant
Information].[Late Payment Title], =[Forms].[Tenant Information].[Late Rent
Text], Yes,

I looked at changing the arguments to the email address etc, which initially
was just [Email address] (and worked until this morning), but changing it to
the full [Forms].[Tenant Information].[Email address] doesn't seem to do it.

Any ideas will be very gratefully received!

Kind Regards,
Russell.

 

[Steve Schapel]

Russell,

Atr first glance, it really would appear to me that there is a problem
specifically with the data that was entered into the [Email address] or
[Late Payment Title] or [Late Rent Text] controls on your form.

I would suggest you remove again the [Forms].[Tenant Information]. from the
macro... or at least if you do enter it, ir should be ! not . i.e. like
this:
=[Forms]![Tenant Information]![Late Payment Title]
But if the macro is being run from an event on that form, it should not be
necessary.

--
Steve Schapel, Microsoft Access MVP

Hi folks,

Been using a small macro from within a form for the last year, and today
it
stopped working. Microsoft did update our computers over night....?

I am getting a 2950 error. "You tried to run a macro or use a method to
carry
out an action, but an expression evaluated to the wrong data type."

Macro sends an email from the information on the Form. My Macro arguments
look like this:

, , , =[Forms].[Tenant Information].[Email address], , , =[Forms].[Tenant
Information].[Late Payment Title], =[Forms].[Tenant Information].[Late
Rent
Text], Yes,

I looked at changing the arguments to the email address etc, which
initially
was just [Email address] (and worked until this morning), but changing it
to
the full [Forms].[Tenant Information].[Email address] doesn't seem to do
it.

Any ideas will be very gratefully received!

__________ Information from ESET Smart Security, version of virus signature database 4247 (20090715) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[Pascoe via AccessMonster.com]

Hey Steve,

Thanks for replying. I tried your suggestion, but no go.

In the end, I took out of the Back End DB some new fields I had added before
it stopped working, and Bingo, back in business. Still doesn't make sense to
me though!

Thanks for your time.
Russell.

Russell,

Atr first glance, it really would appear to me that there is a problem
specifically with the data that was entered into the [Email address] or
[Late Payment Title] or [Late Rent Text] controls on your form.

I would suggest you remove again the [Forms].[Tenant Information]. from the
macro... or at least if you do enter it, ir should be ! not . i.e. like
this:
=[Forms]![Tenant Information]![Late Payment Title]
But if the macro is being run from an event on that form, it should not be
necessary.

Hi folks,

[quoted text clipped - 22 lines]

Any ideas will be very gratefully received!

__________ Information from ESET Smart Security, version of virus signature database 4247 (20090715) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[ABRAHAM]

Hello, i´m getting the same error when I try to send a PDF report via email
from a MS ACCESS 2007 macro.

It happens when I try to generate the email while WINDOWS LIVE MAIL (MY
DEAFULT EMAIL CLIENT) is closed or busy.

then I have to close the error window and retry 3 -4 times until it works.

It seems to me like a time out error since the email client is busier when
it starts up.

Any idea?

Hey Steve,

Thanks for replying. I tried your suggestion, but no go.

In the end, I took out of the Back End DB some new fields I had added before
it stopped working, and Bingo, back in business. Still doesn't make sense to
me though!

Thanks for your time.
Russell.

Russell,

Atr first glance, it really would appear to me that there is a problem
specifically with the data that was entered into the [Email address] or
[Late Payment Title] or [Late Rent Text] controls on your form.

I would suggest you remove again the [Forms].[Tenant Information]. from the
macro... or at least if you do enter it, ir should be ! not . i.e. like
this:
=[Forms]![Tenant Information]![Late Payment Title]
But if the macro is being run from an event on that form, it should not be
necessary.

Hi folks,

[quoted text clipped - 22 lines]

Any ideas will be very gratefully received!

__________ Information from ESET Smart Security, version of virus signature database 4247 (20090715) __________

The message was checked by ESET Smart Security.

http://www.eset.com