Re-POST - It should be a way

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

D - 18 Jan 2005 14:35 GMT

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

Reply to this Message

John Vinson - 18 Jan 2005 22:09 GMT

>Hi:
>
[quoted text clipped - 15 lines]
> " ;***Description: " & Forms![Data Quality Issues Management]!Description,
>True,

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]

Reply to this Message

D - 19 Jan 2005 14:31 GMT

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

> >Hi:
> >
[quoted text clipped - 27 lines]
>
> John W. Vinson[MVP]

Reply to this Message

John Vinson - 19 Jan 2005 20:02 GMT

>Hi John:
>
[quoted text clipped - 5 lines]
>Both addresses are in the table and in the form; each record different
>address.

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]

Reply to this Message

D - 19 Jan 2005 20:38 GMT

Thanks John!

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

Thanks again,

Dan

> >Hi John:
> >
[quoted text clipped - 26 lines]
>
> John W. Vinson[MVP]

Reply to this Message

D - 20 Jan 2005 15:35 GMT

Hi John!

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

Dan

> Thanks John!
>
[quoted text clipped - 34 lines]
> >
> > John W. Vinson[MVP]

Reply to this Message

John Vinson - 20 Jan 2005 20:02 GMT

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

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]

Reply to this Message

D - 21 Jan 2005 19:01 GMT

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!
> >
[quoted text clipped - 9 lines]
>
> John W. Vinson[MVP]

Reply to this Message

John Vinson - 21 Jan 2005 23:37 GMT

>Hi John:
>
[quoted text clipped - 16 lines]
>c) there are 4 email recipients=4 addresses; all of them are in the table
>and in the form

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]

Reply to this Message