I have a names-field which returns values from an address dialog. The values are listed like this (in the doc-property):“Address1”
“Address2”
By using the @MailSend-function the addresses are listed as “Address1; Address2” (as one address, and the lookup fails). I am aware that they should be listed as “Address1” : “Address2”, but haven’t found a OK way to ‘convert’ the values.
As far as I can see, @Implode and @Explode will not solve this. Anyone who have a tip? I will appreciate any help. Thanks in advance.
Regards, Arvid
Subject: @MailSend and multiple recipients
Hi
Please try the following option::
Goto Names Field properties ==> Advanced (3rd Tab) ==> MultiValue Options… in that select seperate values using , delimiter.
May this will resolve.
~Vinay
Subject: @MailSend and multiple recipients
The format of the @mailsend with arguments has 3 parts for e-mail addresses:
to
cc
bcc
These are the first 3 arguments.
If you want the message to go to more than one person (for example) you specify the e-mail addresses as a LIST e.g.
toList:="Fred.bloggs@acme.com":“Janet Street/ACME”
then
@mailsend(tolist;“”;“”;“SUBJECT OF E-mail” etc. etc.)
Because your field is already multivalue:
“Address1”
“Address2”
This is already a ‘list’ and the formula will understand it as:
“Address1”:“Address2”
So, in other words, just use the name of the field as the ‘To’ argument and each address listed in the field should get the e-mail!
Subject: @MailSend and multiple recipients
Just one more thought…
@ReplaceSubstring( ; “;” ; “,” )
This function may work perfectly.
~Vinay