Alert message or Email

[TE]

Help;

I am using access 97, I want to send email when one of the fields [combo
box] is filled from the Drop Down Menu. Is there a way to do it either a
macro or....

Thank you

 

[Steve Schapel]

TE,

In a nutshell, use a SendObject macro on the After Update event of the
combobox. Please post back if you need more specific help.

- Steve Schapel, Microsoft Access MVP

 

[Tameria]

Steve,

Is there a way for me (in Access 97 or 2000) to use
information from a table or query as the body an email?

My dilemna is I am trying to have the contents of a table
sent as an email - not as an attachment. Currently I am
using the SendObject function, but I do not want it to be
an attachment. Is there a way to do this??

-----Original Message-----
TE,

In a nutshell, use a SendObject macro on the After Update event of the
combobox. Please post back if you need more specific help.

- Steve Schapel, Microsoft Access MVP

Help;

I am using access 97, I want to send email when one of the fields [combo
box] is filled from the Drop Down Menu. Is there a way to do it either a
macro or....

Thank you

.

 

[Steve Schapel]

Tameria,

Easiest way to do this is run your SendObject macro from a command
button on a form which is based on your table/query, so the currently
required message text is on the form, and then in the Message Text
argument of the macro, put the equivalent of...
=[Forms]![NameOfForm]![NameOfTextbox]

- Steve Schapel, Microsoft Access MVP

 

[Tameria]

Thanks Steve

-----Original Message-----
Tameria,

Easiest way to do this is run your SendObject macro from a command
button on a form which is based on your table/query, so the currently
required message text is on the form, and then in the Message Text
argument of the macro, put the equivalent of...
=[Forms]![NameOfForm]![NameOfTextbox]

- Steve Schapel, Microsoft Access MVP

Steve,

Is there a way for me (in Access 97 or 2000) to use
information from a table or query as the body an email?

My dilemna is I am trying to have the contents of a table
sent as an email - not as an attachment. Currently I am
using the SendObject function, but I do not want it to be
an attachment. Is there a way to do this??

.

 

[Tameria]

Steve,

I did try this and it worked once (it still attached a
text file) but it is not working anymore. Is there a
specific output file type I should use? I currently have
it set at MSDOS txt.

This is my Message Text Argument:

=[Forms]![Condition Reporting Form for Operators]![DATE]
And [TIME] And [COND] And [HOSP] And [BLD] And [FLOOR] And
[UNIT] And [LNAME] And [FNAME] And [MNAME] And [MRN]

Thank you!

-----Original Message-----
Tameria,

Easiest way to do this is run your SendObject macro from a command
button on a form which is based on your table/query, so the currently
required message text is on the form, and then in the Message Text
argument of the macro, put the equivalent of...
=[Forms]![NameOfForm]![NameOfTextbox]

- Steve Schapel, Microsoft Access MVP

Steve,

Is there a way for me (in Access 97 or 2000) to use
information from a table or query as the body an email?

My dilemna is I am trying to have the contents of a table
sent as an email - not as an attachment. Currently I am
using the SendObject function, but I do not want it to be
an attachment. Is there a way to do this??

.

 

[Steve Schapel]

Tameria,

If I understand you correctly, you do not wish to attach any file to
the email. If so, the Object Type, Object Name, and Output Format
arguments of the SendObject macro should be left blank.

Ther syntax of your Message Text is incorrect. You would need to
qualify each field to be included, like this...
=[Forms]![Condition Reporting Form for Operators]![DATE] &
[Forms]![Condition Reporting Form for Operators]![TIME] &
[Forms]![Condition Reporting Form for Operators]![COND] ... etc etc

However, I wouldn't do this concatenation in the macro argument. I
would do it in the query that ther form is based on, e.g....
Text4Msg: [Date] & [Time] & [Cond] & [Hosp] & ...
put a textbox onthe form bound to this concatenated field, and then
just refer to the one control in the macro argument.

By the way, as an aside, a hint... The words Date and Time have a
special meaning in Access, and it is not a good idea to use them as
the names of fields.

- Steve Schapel, Microsoft Access MVP

Steve,

I did try this and it worked once (it still attached a
text file) but it is not working anymore. Is there a
specific output file type I should use? I currently have
it set at MSDOS txt.

This is my Message Text Argument:

=[Forms]![Condition Reporting Form for Operators]![DATE]
And [TIME] And [COND] And [HOSP] And [BLD] And [FLOOR] And
[UNIT] And [LNAME] And [FNAME] And [MNAME] And [MRN]

Thank you!

-----Original Message-----
Tameria,

Easiest way to do this is run your SendObject macro from a command
button on a form which is based on your table/query, so the currently
required message text is on the form, and then in the Message Text
argument of the macro, put the equivalent of...
=[Forms]![NameOfForm]![NameOfTextbox]

- Steve Schapel, Microsoft Access MVP

Steve,

Is there a way for me (in Access 97 or 2000) to use
information from a table or query as the body an email?

My dilemna is I am trying to have the contents of a table
sent as an email - not as an attachment. Currently I am
using the SendObject function, but I do not want it to be
an attachment. Is there a way to do this??

.

 

[Tameria]

You do have the correct understanding, Thanks.
Would I be able to use this same methodology to pull
directly from a table?

-----Original Message-----
Tameria,

If I understand you correctly, you do not wish to attach any file to
the email. If so, the Object Type, Object Name, and Output Format
arguments of the SendObject macro should be left blank.

Ther syntax of your Message Text is incorrect. You would need to
qualify each field to be included, like this...
=[Forms]![Condition Reporting Form for Operators]![DATE] &
[Forms]![Condition Reporting Form for Operators]![TIME] &
[Forms]![Condition Reporting Form for Operators]! [COND] ... etc etc

However, I wouldn't do this concatenation in the macro argument. I
would do it in the query that ther form is based on, e.g....
Text4Msg: [Date] & [Time] & [Cond] & [Hosp] & ...
put a textbox onthe form bound to this concatenated field, and then
just refer to the one control in the macro argument.

By the way, as an aside, a hint... The words Date and Time have a
special meaning in Access, and it is not a good idea to use them as
the names of fields.

- Steve Schapel, Microsoft Access MVP

Steve,

I did try this and it worked once (it still attached a
text file) but it is not working anymore. Is there a
specific output file type I should use? I currently have
it set at MSDOS txt.

This is my Message Text Argument:

=[Forms]![Condition Reporting Form for Operators]![DATE]
And [TIME] And [COND] And [HOSP] And [BLD] And [FLOOR] And
[UNIT] And [LNAME] And [FNAME] And [MNAME] And [MRN]

Thank you!

-----Original Message-----
Tameria,

Easiest way to do this is run your SendObject macro

from
a command

button on a form which is based on your table/query, so the currently
required message text is on the form, and then in the Message Text
argument of the macro, put the equivalent of...
=[Forms]![NameOfForm]![NameOfTextbox]

- Steve Schapel, Microsoft Access MVP

wrote:

Steve,

Is there a way for me (in Access 97 or 2000) to use
information from a table or query as the body an email?

My dilemna is I am trying to have the contents of a table
sent as an email - not as an attachment. Currently I am
using the SendObject function, but I do not want it to be
an attachment. Is there a way to do this??

.

.

 

[Tameria]

Thanks Steve - You've been a great help. I still don't
have this working quite yet but I will get it soon enough.

-----Original Message-----
Tameria,

Theoretically, yes you could "pull" the data from a table, using a
domain aggregate function such as DLookup(). However, in practice,
the method we have been discussing (i.e. query => form => macro
argument) is much simpler. For one thing, I believe the macro
argument is restricted to 255 characters, which you would soon reach
if you are doing...
DLookup("[Date]","YourTableName","<YourCondition>") & " " &
DLookup("[Time]","YourTableName.... etc

- Steve Schapel, Microsoft Access MVP

You do have the correct understanding, Thanks.
Would I be able to use this same methodology to pull
directly from a table?

.