How to add multiple entries for a single destination

ATTENTION: This forum is no longer active. Please navigate to our new support site at https://support.starfishetl.com/
Viewing 7 posts (of 7 total)
Sebastien
User - Author
Post count: 17
#1

Hello there

I am here helping my college out with migrating from Goldmine to MCRM. I have a little question concerning the fact of setting up the correct from's and to's when migrating the emails. I use "scripted value" for getting the to's with vb script and try to put more than one email respectively more than one person as a result. But the issue is, that starfish does not let me doing it. A simple code like the one bellow does not even work:

  1. Function ScriptedField
  2. 	ScriptedField="<a href="mailto:test@test.com">test@test.com</a>;<a href="mailto:test2@test2.com">test2@test2.com</a>"
  3. End Function

'test@test.com;test2@test2.com-->in the database it is saved this way when adding an entry manually

It is not working and if I replace the semicolon with a space, it takes only the last email address and in the database there is only one recipient. How do I return more than one person for the "To" field? I managed to get all of the to's from the email message but unfortunately cannot assign them. I also tried to use the "torecepients" field in starfish but this does not assign the values correctly meaning the "torecepient" in the database is always NULL when using it.

I hope you understand what I am asking for otherwise do not hesitate to ask me. Thank you in advance, I am looking forward to hear from you.

Regards
Pascal

Comments (7)

Aron Hoekstra's picture Aron Hoekstra
Administrator
Post count: 2
#2

I'd like to help but first can you tell me, are you using the "Microsoft CRM" or "Microsoft CRM 2011" connector?

Log in to post comments
Sebastien's picture Sebastien
User - Author
Post count: 17
#3

We are using Microsoft CRM 2011 connector.

Log in to post comments
Aron Hoekstra's picture Aron Hoekstra
Administrator
Post count: 2
#4

Ok I'll take a closer look into this. Have you tried a comma?

Log in to post comments
Sebastien's picture Sebastien
User - Author
Post count: 17
#5

yes and also spaces

Log in to post comments
Sebastien's picture Sebastien
User - Author
Post count: 17
#6

Hello,

Here is a sample of the code I did and still don't know how to add multiple recipients for emails.

  1. dim id
  2. 	id = SmartLookup("contact","contactid","emailaddress1='" & to & "'", True)
  3. 		if id <> "" then
  4. 			ScriptedField="MSCRMLOOKUP,contact," & id

The problem seems to be 'How to, on a ScriptedField, that will perform an 'MSCRMLookup' to retrieve more than one id, which character deliminator to use, how, to format the result in a way that MSCRM will agree with populating the 'to' field with more than one recipients.

Best regards
Séb

Log in to post comments
Aron Hoekstra's picture Aron Hoekstra
Administrator
Post count: 2
#7

When populating raw email addresses, you should use the ToRecipients field. If you want to specify hard links to Contacts or Accounts, you'd use the 'to' field, which is a 'partylist' type field. When using partylists, you must supply the GUID's in the to_Ids field semicolon separated:
"{66AA39A3-B585-E211-BACF-00155D026E18};{98E635DC-39C9-E211-A6CB-00155D027912};"

Then you must supply the name of each of these entities to the to_LogicalNames field:
"contact;contact;"

Log in to post comments
Sebastien's picture Sebastien
User - Author
Post count: 17
#8

Ok, correct my if I'm wrong, on a scripted value, I can insert multiple GUID for recipients to the to field: it would give something like this
ScriptedField="MSCRMLOOKUP,contact," & {id1;id2;id3}

What is the to_lds?

Also, I don't understand this part of your message:

Then you must supply the name of each of these entities to the to_LogicalNames field:
"contact;contact;"

So far, may tests were not successful, please, provide me some more detailed information.

Log in to post comments
Viewing 7 posts (of 7 total)

Forum Login

Login or sign up for our forums to connect to the user community.

Reply

You must log in to post.

Not a Member? Register.