Hi,Is there a formula with which i can get all the email addresses in the TO field and CC field into the email variable. Here is an example:
Im trying to create a button which when clicked should send email to the people in the TO, CC & BCC fields.
emailTo:=“FirstName1 LastName1 /CONTRACTOR/XYZ/MNCHD”;
emailCc:=“FirstName2 LastName2 /CONTRACTOR/XYZ/MNCHD”;
emailBcc:=“FirstName3 LastName3 /CONTRACTOR/XYZ/MNCHD”;
@MailSend(emailTo;emailCc;emailBcc;subject;remark;body);
Instead of hardcoding the email addresses, can i get the email addresses from the TO, CC & BCC?
Regards,
Kalyan Verma
Subject: Voting Buttons in Notes
not sure from where you would click the button but if it is from the email then this would do:
emailTo:=sendTo;
emailCc:=copyto;
emailBcc:=blindcopyto;
>
@MailSend(emailTo;emailCc;emailBcc;subject;remark;body);
Subject: RE: Voting Buttons in Notes
Also im trying to define a custom field within the email body, so that that can be used in the Button Hotspot Code. Is there a way i can create that?
Subject: RE: Voting Buttons in Notes
I am not totally sure why you are having difficulty- if you have a field called "Sendto", "CopyTo", & "BlindCopyTo" on your form- and they allow mulitple values- @mailsend will use them seamlessly. The solution offered works if you have called them something else.
Now, on the body field- a) @mailsend allows for a “Remark”
[@MailSend( sendTo ; copyTo ; blindCopyTo ; subject ; remark ; bodyFields ; [ flags ] ) ] - so you could capture that field for the remark- or you can cancatenate body fields by doing:
body1 := ThisField;
Body2 := ThatField
Body3 := “Some static text.”
body := Body1 + @newline + Body2 + @newline + Body3
Tom
Subject: RE: Voting Buttons in Notes
Hi Tom,Its working perfectly fine. Thanks.
Subject: RE: Voting Buttons in Notes
Awesome, Thanks a mil. That helped.