Attention: The Marketo Community will undergo scheduled maintenance on Tuesday, August 20th between 10-11 PM PDT. During this time, the Community and its content will not be accessible. We apologize for any inconvenience this may cause.
Hello,
I have been looking through the forums for an answer to my issue however, am yet to discover anything that provides enough guidance, hoping someone may be able to help.
We need to send an email to clients informing them of changes to their logins.
We will need to show each client individual information. Prior to having Marketo I would have just completed field merge in Campaign Monitor using a excel sheet. The data we need does not live in Salesforce and cannot be placed there.
So I am hoping there is a simplistic solution to field/mail merging information from a excel sheet into a email blast according to each person receiving it.
Example:
Spreadsheet
Account Name Current Email Username New Email
Default Business sales@email.com John.Smith John.smith@email.com
The copy in the EDM being:
Hi John,
Your current email {current email} will no longer work, please use your new unique email {New Email} and {Username} to login from now on.
Any help would great/
Thanks
Marketo can't send directly "to" rows in a sheet: there is no UI* function for one-time-use of values in a sheet that are then discarded.
Instead, you'd import the sheet full of lead values into Marketo and send to the (static) list of folks who were just merged in.
If you wanted to minimize the need for new fields, you could combine all the one-time values into one big Textarea field, then parse (split) the contents of that field using a Velocity ("Email Script") token.
* You could build such a function using the API, but that's presumably off-topic.
The other work round would be by creating this whole message in Excel and upload that message to a Textarea field like comment or notes and use that as a token inside your email. The excel will look like below:
The the formula you should use to populate the Message should be following:
="Hi "&C2&","&CHAR(10)&CHAR(10)&"Your current email "&B2&" will no longer work, please use your new unique email "&E2&" and "&D2&" to login from now on."
Hope this will help.
Regards,
Amit