Re-POST - It should be a way

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi:

I still could not do it:


How do I add another recipient to this function, separated by what? or can I
add an if statement to send to R1 or R2 if condition met?

Function Send_Open_Incident()
On Error GoTo Send_Open_Incident_Err

DoCmd.SendObject , "", "RichTextFormat(*.rtf)", Forms![Data Quality
Issues Management]!OpenedBy, Forms![Data Quality Issues Management]!Email,
Forms![Data Quality Issues Management]!OEmail, "Closing Incident", _
"Thank You for contacting the Data Standards Project Team. The details of
your recent incident are listed below. If you would like to know the status,
please contact us and reference your incident number below. Incident No: " &
Forms![Data Quality Issues Management]!IncidentNumber & _
" ;***Description: " & Forms![Data Quality Issues Management]!Description,
True,

Tahnks,

Dan
 
Hi:

I still could not do it:


How do I add another recipient to this function, separated by what? or can I
add an if statement to send to R1 or R2 if condition met?

Function Send_Open_Incident()
On Error GoTo Send_Open_Incident_Err

DoCmd.SendObject , "", "RichTextFormat(*.rtf)", Forms![Data Quality
Issues Management]!OpenedBy, Forms![Data Quality Issues Management]!Email,
Forms![Data Quality Issues Management]!OEmail, "Closing Incident", _
"Thank You for contacting the Data Standards Project Team. The details of
your recent incident are listed below. If you would like to know the status,
please contact us and reference your incident number below. Incident No: " &
Forms![Data Quality Issues Management]!IncidentNumber & _
" ;***Description: " & Forms![Data Quality Issues Management]!Description,
True,
Click to expand...


I have no idea what you mean by "R1 or R2 if conditions met". What are
the fields Email and OEmail (the two recipients???) What addresses are
you trying to send this to? Where can they be found in your database -
on a Form, in a Table (one record or several)?

Remember, D: *you* can see your database. You can remember the
previous two or three messages you may have sent. The volunteers on
these newsgroups cannot; and we have looked at hundreds of other
messages since reading your last message, if indeed we saw it at all.

John W. Vinson[MVP]
 
Hi John:

Thanks for the answer! Please find below the explanation:

R1=OEmail=first recipient's e-mail address
R2=Email=2nd recipient's e-mail address

Both addresses are in the table and in the form; each record different
address.

Thanks again,

Dan

John Vinson said:
Hi:

I still could not do it:


How do I add another recipient to this function, separated by what? or can I
add an if statement to send to R1 or R2 if condition met?

Function Send_Open_Incident()
On Error GoTo Send_Open_Incident_Err

DoCmd.SendObject , "", "RichTextFormat(*.rtf)", Forms![Data Quality
Issues Management]!OpenedBy, Forms![Data Quality Issues Management]!Email,
Forms![Data Quality Issues Management]!OEmail, "Closing Incident", _
"Thank You for contacting the Data Standards Project Team. The details of
your recent incident are listed below. If you would like to know the status,
please contact us and reference your incident number below. Incident No: " &
Forms![Data Quality Issues Management]!IncidentNumber & _
" ;***Description: " & Forms![Data Quality Issues Management]!Description,
True,
Click to expand...


I have no idea what you mean by "R1 or R2 if conditions met". What are
the fields Email and OEmail (the two recipients???) What addresses are
you trying to send this to? Where can they be found in your database -
on a Form, in a Table (one record or several)?

Remember, D: *you* can see your database. You can remember the
previous two or three messages you may have sent. The volunteers on
these newsgroups cannot; and we have looked at hundreds of other
messages since reading your last message, if indeed we saw it at all.

John W. Vinson[MVP]
Click to expand...
 
Hi John:

Thanks for the answer! Please find below the explanation:

R1=OEmail=first recipient's e-mail address
R2=Email=2nd recipient's e-mail address

Both addresses are in the table and in the form; each record different
address.
Click to expand...

If you will only have two recipients, try

DoCmd.SendObject , "", "RichTextFormat(*.rtf)", _
Forms![Data Quality Issues Management]!OpenedBy, _
[Forms]![Data Quality Issues Management]!Email & _
(";" + Forms![Data Quality Issues Management]!OEmail), _
"Closing Incident", _
"Thank You for contacting the Data Standards Project Team. The details
of your recent incident are listed below. If you would like to know
the status, please contact us and reference your incident number
below. Incident No: " &
Forms![Data Quality Issues Management]!IncidentNumber & _
" ;***Description: " & Forms![Data Quality Issues
Management]!Description,
True,

That is, concatenate the two addresses into a string with a semicolon
delimiter.

John W. Vinson[MVP]
 
Thanks John!

I have 4 recipients but I will try to concatenate them to see?!

Thanks again,

Dan

John Vinson said:
Hi John:

Thanks for the answer! Please find below the explanation:

R1=OEmail=first recipient's e-mail address
R2=Email=2nd recipient's e-mail address

Both addresses are in the table and in the form; each record different
address.
Click to expand...

If you will only have two recipients, try

DoCmd.SendObject , "", "RichTextFormat(*.rtf)", _
Forms![Data Quality Issues Management]!OpenedBy, _
[Forms]![Data Quality Issues Management]!Email & _
(";" + Forms![Data Quality Issues Management]!OEmail), _
"Closing Incident", _
"Thank You for contacting the Data Standards Project Team. The details
of your recent incident are listed below. If you would like to know
the status, please contact us and reference your incident number
below. Incident No: " &
Forms![Data Quality Issues Management]!IncidentNumber & _
" ;***Description: " & Forms![Data Quality Issues
Management]!Description,
True,

That is, concatenate the two addresses into a string with a semicolon
delimiter.

John W. Vinson[MVP]
Click to expand...
 
Hi John!

Thanks again! but does not take the second address after concanetation!

Dan

D said:
Thanks John!

I have 4 recipients but I will try to concatenate them to see?!

Thanks again,

Dan

John Vinson said:
Hi John:

Thanks for the answer! Please find below the explanation:

R1=OEmail=first recipient's e-mail address
R2=Email=2nd recipient's e-mail address

Both addresses are in the table and in the form; each record different
address.
Click to expand...

If you will only have two recipients, try

DoCmd.SendObject , "", "RichTextFormat(*.rtf)", _
Forms![Data Quality Issues Management]!OpenedBy, _
[Forms]![Data Quality Issues Management]!Email & _
(";" + Forms![Data Quality Issues Management]!OEmail), _
"Closing Incident", _
"Thank You for contacting the Data Standards Project Team. The details
of your recent incident are listed below. If you would like to know
the status, please contact us and reference your incident number
below. Incident No: " &
Forms![Data Quality Issues Management]!IncidentNumber & _
" ;***Description: " & Forms![Data Quality Issues
Management]!Description,
True,

That is, concatenate the two addresses into a string with a semicolon
delimiter.

John W. Vinson[MVP]
Click to expand...
Click to expand...
 
Hi John!

Thanks again! but does not take the second address after concanetation!
Click to expand...

I'm sorry, D, but I'll not be able to help with this information.

I have NO notion a) what expression you actually used, b) where the
second address might be, c) what you mean by four addresses, d) where
they are stored.

Remember... *you* can see your computer. We cannot.

John W. Vinson[MVP]
 
Hi John:

a)Is not an expression; please see below:

Function Send_Open_Incident()
On Error GoTo Send_Open_Incident_Err

DoCmd.SendObject , "", "RichTextFormat(*.rtf)", Forms![Data Quality
Issues Management]!OpenedBy, Forms![Data Quality Issues Management]!Email,
Forms![Data Quality Issues Management]!OEmail, "Closing Incident", _
"Thank You for contacting the Data Standards Project Team. The details of
your recent incident are listed below. If you would like to know the status,
please contact us and reference your incident number below. Incident No: " &
Forms![Data Quality Issues Management]!IncidentNumber & _
" ;***Description: " & Forms![Data Quality Issues Management]!Description,
True,

b) the second address could be in to: or cc
c) there are 4 email recipients=4 addresses; all of them are in the table
and in the form

Thanks,

Dan
 
Hi John:

a)Is not an expression; please see below:

Function Send_Open_Incident()
On Error GoTo Send_Open_Incident_Err

DoCmd.SendObject , "", "RichTextFormat(*.rtf)", Forms![Data Quality
Issues Management]!OpenedBy, Forms![Data Quality Issues Management]!Email,
Forms![Data Quality Issues Management]!OEmail, "Closing Incident", _
"Thank You for contacting the Data Standards Project Team. The details of
your recent incident are listed below. If you would like to know the status,
please contact us and reference your incident number below. Incident No: " &
Forms![Data Quality Issues Management]!IncidentNumber & _
" ;***Description: " & Forms![Data Quality Issues Management]!Description,
True,

b) the second address could be in to: or cc
c) there are 4 email recipients=4 addresses; all of them are in the table
and in the form
Click to expand...

I'm sorry D.

I'm going to have to give up. I'd suggest you repost again and see if
someone else can help.

I've asked repeatedly for you to describe your table and the
fieldnames in which these addresses are stored. You have not done so.
I am unable to read your mind or to see your table structure, and
therefore I am unable to help you. When you repost, it would be best
if you posted this information - post your actual Access table field
names, and perhaps a sample of a couple of rows of the table showing
the data in that table.


John W. Vinson[MVP]
 
Back
Top