The Community is hosting an End of Summer sweepstakes! Participants must complete tasks to earn tickets that will enter them with a chance to win a free year of Constant Contact and other great prizes!*
*No Purchase Necessary. For Official Rules, visit here. Constant Contact’s End of Summer 2020 Sweepstakes ends on October 16th, 2020 at 11:59 PM EST.

Daily emails with dynamic contents fetched from our database automatically

Highlighted
Occasional Participant

Daily emails with dynamic contents fetched from our database automatically

Hello,

 

We want to use ContantContacts for sending different newsletters emails to a big (30000+) list of users. Following are some more details:

 

There are different newsletter emails -

1. Daily newsletter - Sending quote of the day.

    a. We will set the HTML format of the email

    b. Same email format but contents will be fetched from our database and go in email automatically on daily basis

2. Weekly newsletters:

    a. We will set the HTML format of the email
    b. Our Admin will select which content to be sent

    c. Will select the list of members for sending email

3. Manual:

    a. We will set the HTML format of the email
    b. Contents and members will be selected by Admin

 

Our end customer has already spoken with ContantContact support and is very happy with the pricing and other feature.

 

Please please guide us on how this will work using contantcontacts.

 

Best Regards,

 

Dnyanesh

 

19 REPLIES 19
Highlighted
Moderator

Re: Daily emails with dynamic contents fetched from our database automatically

We have a couple of options for you.

 

1. Use our UI to manually create these emails in a template or custom code.  This uses our basic UI functionality and requires no development.  It is likely to be tough to get the info from the SQL database daily but not impossible. 

 

2. Use our API to build a custom integration for creating and sending the email campaigns.  This is an advanced option and requires custom coding from a developer on your side.  If this is interesting to you and your client, you can find our documentation on creating and scheduling an email campaign here:http://developer.constantcontact.com/docs/email-campaigns/email-campaign-api-index.html

 

We also have wrapper libraries to speed up development in PHP, C#, Ruby, Java and ObjectiveC.  If you run into any problems using our API we can certainly support that.  However, we are not able to support custom HTML designs and issues with HTML development of the actual newsletters.  Hope this helps!

Dave Berard
Senior Product Manager, Constant Contact
Highlighted
Occasional Participant

Re: Daily emails with dynamic contents fetched from our database automatically

Thanks Dave!

 

You mentioned that getting data from SQL Database is tough but not impossible. Would like to know more about this on how to achieve it.

 

Best Regards,

 

Dnyanesh

 

Highlighted
Moderator

Re: Daily emails with dynamic contents fetched from our database automatically

It was in the context of a non-developer doing that.  Programatically, it's pretty simple to get content from the SQL database.  But if you have someone manually pulling that content from the SQL database, logging into Constant Contact and copy/pasting the content in, that can be tedious.  If you have a system admin or a developer doing that, it could also be fairly simple.  All depends on who the target user is doing the manual pulling of the content and doing the copy/paste.

Dave Berard
Senior Product Manager, Constant Contact
Highlighted
Occasional Participant

Re: Daily emails with dynamic contents fetched from our database automatically

We are a development company and will do pulling from SQL. But how to pass it to the palceholders in the email template is a query now.

 

Best Regards,

 

Dnyanesh

 

Highlighted
Moderator

Re: Daily emails with dynamic contents fetched from our database automatically

We don't have any options for placeholder text.  The two options we offer are:

 

  1.  WYSIWYG authoring environment.  Manually create a template, use a WYSIWYG editor to customize the email including copy/paste of any content from 3rd party sources (such as your SQL database).  Manual customization of all content through our WYSIWYG editor tools with optional code view if you want to dig into the raw HTML of the content and customize to some degree.
  2. Custom Code experience.  Send us a complete and ready to send HTML document and all of the related data (subject, to, from, etc.) through the API or through our UI by copy/paste.  No access to templates or our WYSIWYG content is possible through this method.  Everything must be designed and built outside of Constant Contact and sent to us complete and ready to go.  This is the option you would take if you wanted to fully automate everything through a custom developed solution using our API.  No merging needed as the HTML document must be supplied to us as an entire entity including all content.

Does that make sense?

Dave Berard
Senior Product Manager, Constant Contact
Highlighted
Occasional Participant

Re: Daily emails with dynamic contents fetched from our database automatically

Hi Dave, 

 

We will try these options and let you know if we need anything more. 

 

Thanks for your support! 

 

Best Regards, 

 

Dnyanesh 

 

Highlighted
Occasional Participant

Re: Daily emails with dynamic contents fetched from our database automatically

Hi Dave,

 

I am Vijay, working with DnyaneshG.

 

While trying Create and Schedule a Campaign API, I am getting below error:

 

Error Creating Campaign

 

Array
(
    [0] => Array
        (
            [error_key] => http.status.bad_request
            [error_message] => Please enter an address
        )

)

 

 

for attached email template.

Could you please let me know what is remaining to complete from my account settings?

 

my username is aressvijay

 

 

Thanks

Vijay

 

 

 

 

 

 

Highlighted
Moderator

Re: Daily emails with dynamic contents fetched from our database automatically

Haven't had a chance to run it through on my side but looking at the page source there is white space after the closing </html>.  If removing that doesn't fix the problem for you, let me know and our support staff will try to run it through our API.  It would be very helpful if you could email us your JSON payload that is failing to webservices@constantcontact.com.

Dave Berard
Senior Product Manager, Constant Contact
Highlighted
Occasional Participant

Re: Daily emails with dynamic contents fetched from our database automatically

Hi Dave,

 

Thanks for quick replay!

 

Is this something related to my account settings?

 

By reading community posts I got to solve the html tag related issue.

 

Now I am getting below error:

Array
(
    [0] => Array
        (
            [error_key] => http.status.bad_request
            [error_message] => Please enter an address
        )

)

 

I believe this is something related to my account setting.

 

Please advise.

 

 

Thanks

Vijay

 

Developer Portal

View API documentation, code samples, get your API key.

Visit Page

Constant Contact 2020 End of Summer Community Sweepstakes!

The Constant Contact User Community is hosting a sweepstakes. The more you participate, the more chances you have to win! Read on to learn more...

Read More
Featured