Got a 'How do I' question? Join 'Ask a Trainer' Monday to Friday, 11am to 4pm ET for instant help and pro tips!

Sending customers a list of orders of part X

SOLVED
Go to solution
ScottM47
Rookie
0 Votes

Is it possible to use merge fields to insert a complete table (in this case a list of orders, qtys, etc.) for each customer receiving the e-mail?  This data would all be in a CSV.  The "table" would be a single field in any format required (text,csv,html,etc.).

That's because I'm assuming there is no recursive merging like you can do in 

 

EXAMPLE:

Dear Customer X

Our records show you've bought part Y - etc...

 

SHIPMENT DATE PO QTY
07/01/2024 XX1 24
07/15/2024 XX2 36
08/15/2024 XX3 10

 

1 ACCEPTED SOLUTION
William_A
Administrator
0 Votes

You're welcome to try via the custom code editor, however since the email would be wholly custom-made, our hands would be tied on providing any insight or troubleshooting if the code isn't working as you'd intend.

 

These articles would likely be the most useful:

Create an email with custom HTML code

Add dynamic links to a custom code email

Using variable tags in Constant Contact email, landing page, and SMS editors

 


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
William A
Community & Social Media Support

View solution in original post

3 REPLIES 3
William_A
Administrator
0 Votes

Hello @ScottM47 ,

 

There isn't a way to accomplish this in the email builder, since it's not built for pulling that kind of info and compiling it in either an auto-generated or manually-created way.


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
William A
Community & Social Media Support
ScottM47
Rookie
0 Votes

Thanks for the quick feedback.

 

So just to be clear - I couldn't have an html coded table or plan text table as a merge field? (examples below)

HTML

"<table><tr><th>SHIP DATE</th><th>QTY</th><th>PART ID</th><th>ORDER ID</th><th>SHIP TO</th></tr><tr><td>2024-10-23</td><td>3</td><td>XXX</td><td>YYY</td><td>1</td></tr><tr><td>2024-10-23</td><td>3</td><td>XXX2</td><td>YYY2</td><td>1</td></tr></table>"

 

PLAIN TEXT with tabs and line feeds

"SHIP DATE QTY PART ID ORDER ID SHIP TO

2024-10-23 3 XXX YYY1 1

2024-10-23 3 XXX2 YYY2 1"

William_A
Administrator
0 Votes

You're welcome to try via the custom code editor, however since the email would be wholly custom-made, our hands would be tied on providing any insight or troubleshooting if the code isn't working as you'd intend.

 

These articles would likely be the most useful:

Create an email with custom HTML code

Add dynamic links to a custom code email

Using variable tags in Constant Contact email, landing page, and SMS editors

 


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
William A
Community & Social Media Support
  • Avatar

    Featured Article

    Use Sections to Build Email Campaigns Faster and Improve Engagement Rates

    Using Sections while designing your marketing email not only increases your own efficiency but helps you to deliver a more friendly, organized message. Check out some of the key benefits of using sections in email.

    See Article
  • Avatar

    Featured Thread

    Casual Conversations: What's your go-to playlist?

    If you listen to music while you work, share your playlist below so we can be inspired and maybe find some new music!

    View thread
  • Avatar

    Featured Thread

    Ready, Set, Send Reflections

    The Ready, Set, Send Challenge has finished! Let's reflect on the wins and accomplishments over the last six weeks.

    Join challenge
Updates
Just Getting Started?

We’re here to help you grow. With how-to tutorials, courses, getting-started guides, videos and step-by-step instructions to start and succeed with Constant Contact.

Start Here

73% of SMBs express doubt that their marketing strategy is effective. Does this sound familiar? Read our Small Business Now Report to learn how you can tweak your strategy to see better results.

Go read our article
Upcoming Webinars
NOV 14
'Tis the Season for Last-Minute Holiday Marketing
2PM - 3PM EST