Sending email to list based on Custom Field values | Community
Skip to main content
A
Anonymous
July 3, 2017
Solved

Sending email to list based on Custom Field values

  • July 3, 2017
  • 1 reply
  • 2665 views

Hi, new user here.

I've created a custom field in my Marketo database called "Vendor Codes". Each vendor code can have multiple emails attached to it. Is it possible to create a smart list based on an uploaded list of vendor codes?

For example, I have a list of 100 vendor codes. Let's say on average, there are 3 emails associated with each vendor code. So I'd like to send 300 emails to all 300 people. What is the best way to do this within Marketo? Or do I have to create a fancy INDEXED vlookup table to look up multiple values referenced per vendor code, then create a separate list to upload?

Thanks!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Gerard_Donnell4

OK Jay Wei​ I think I am following you.  I'm assuming you are wanting to send them all the same email?

If so what I would do is go into the smart list section and search for your field "Vendor Codes" and drag it into the smart list area.  Once there I would make the selection "is" and then hit the little green plus sign to the right of the input field.  A popup will appear allowing you to add multiple values.  I would then just paste in a list of all the vendor codes that you wish to email. 

That should now pull in everyone who has one of those vendor codes.  I have added screenshots below however I do not have a vendor codes field so I have swapped it with the Member of List field.

Let me know if this answers your question.

1 reply

Gerard_Donnell4
Gerard_Donnell4
New Participant
July 3, 2017

Hi Jay,

Im not sure I follow your question but you should be able to segment the leads based on vendor code in your smart list section.  You could also use the "send" flow step and add choices like "If vendor code is XXX send this email else send a different email".  

Can you give a bit more information about "So I'd like to send 300 emails to all 300 people"?

Thanks,

Gerard

A
Anonymous
July 3, 2017

Thanks for the reply Gerard,

Your suggestion is helpful if the number of vendor codes I'd like to send to is small (~10 or less). It would be easy to add "if Vendor code is XXX" and do this for 10 vendor codes. Unfortunately, my list has ~100 vendor codes.

Sorry if I wasn't clear about the number of emails. So, I'd like to send an email to 100 vendors. But each of these vendors have multiple points of contact (e.g. some vendors have 1 email contact, others may have as many as 5). Let's assume, that in this list of 100 vendors, there are 300 points of contact. So I'd like to send a communication to all 300 of these people. I have a list of these 100 vendor codes and am wondering how best to segment or send an email to the 300 email contacts associated with this list of 100 vendor codes.

Any guidance would be greatly appreciated! Thank you!

Gerard_Donnell4
Gerard_Donnell4Accepted solution
New Participant
July 3, 2017

OK Jay Wei​ I think I am following you.  I'm assuming you are wanting to send them all the same email?

If so what I would do is go into the smart list section and search for your field "Vendor Codes" and drag it into the smart list area.  Once there I would make the selection "is" and then hit the little green plus sign to the right of the input field.  A popup will appear allowing you to add multiple values.  I would then just paste in a list of all the vendor codes that you wish to email. 

That should now pull in everyone who has one of those vendor codes.  I have added screenshots below however I do not have a vendor codes field so I have swapped it with the Member of List field.

Let me know if this answers your question.

Terms & ConditionsAccessibility statement

Loading footer...