Alpha Software Mobile Development Tools:   Alpha Anywhere    |   Alpha TransForm subscribe to our YouTube Channel  Follow Us on LinkedIn  Follow Us on Twitter  Follow Us on Facebook

Announcement

Collapse

The Alpha Software Forum Participation Guidelines

The Alpha Software Forum is a free forum created for Alpha Software Developer Community to ask for help, exchange ideas, and share solutions. Alpha Software strives to create an environment where all members of the community can feel safe to participate. In order to ensure the Alpha Software Forum is a place where all feel welcome, forum participants are expected to behave as follows:
  • Be professional in your conduct
  • Be kind to others
  • Be constructive when giving feedback
  • Be open to new ideas and suggestions
  • Stay on topic


Be sure all comments and threads you post are respectful. Posts that contain any of the following content will be considered a violation of your agreement as a member of the Alpha Software Forum Community and will be moderated:
  • Spam.
  • Vulgar language.
  • Quotes from private conversations without permission, including pricing and other sales related discussions.
  • Personal attacks, insults, or subtle put-downs.
  • Harassment, bullying, threatening, mocking, shaming, or deriding anyone.
  • Sexist, racist, homophobic, transphobic, ableist, or otherwise discriminatory jokes and language.
  • Sexually explicit or violent material, links, or language.
  • Pirated, hacked, or copyright-infringing material.
  • Encouraging of others to engage in the above behaviors.


If a thread or post is found to contain any of the content outlined above, a moderator may choose to take one of the following actions:
  • Remove the Post or Thread - the content is removed from the forum.
  • Place the User in Moderation - all posts and new threads must be approved by a moderator before they are posted.
  • Temporarily Ban the User - user is banned from forum for a period of time.
  • Permanently Ban the User - user is permanently banned from the forum.


Moderators may also rename posts and threads if they are too generic or do not property reflect the content.

Moderators may move threads if they have been posted in the incorrect forum.

Threads/Posts questioning specific moderator decisions or actions (such as "why was a user banned?") are not allowed and will be removed.

The owners of Alpha Software Corporation (Forum Owner) reserve the right to remove, edit, move, or close any thread for any reason; or ban any forum member without notice, reason, or explanation.

Community members are encouraged to click the "Report Post" icon in the lower left of a given post if they feel the post is in violation of the rules. This will alert the Moderators to take a look.

Alpha Software Corporation may amend the guidelines from time to time and may also vary the procedures it sets out where appropriate in a particular case. Your agreement to comply with the guidelines will be deemed agreement to any changes to it.



Bonus TIPS for Successful Posting

Try a Search First
It is highly recommended that a Search be done on your topic before posting, as many questions have been answered in prior posts. As with any search engine, the shorter the search term, the more "hits" will be returned, but the more specific the search term is, the greater the relevance of those "hits". Searching for "table" might well return every message on the board while "tablesum" would greatly restrict the number of messages returned.

When you do post
First, make sure you are posting your question in the correct forum. For example, if you post an issue regarding Desktop applications on the Mobile & Browser Applications board , not only will your question not be seen by the appropriate audience, it may also be removed or relocated.

The more detail you provide about your problem or question, the more likely someone is to understand your request and be able to help. A sample database with a minimum of records (and its support files, zipped together) will make it much easier to diagnose issues with your application. Screen shots of error messages are especially helpful.

When explaining how to reproduce your problem, please be as detailed as possible. Describe every step, click-by-click and keypress-by-keypress. Otherwise when others try to duplicate your problem, they may do something slightly different and end up with different results.

A note about attachments
You may only attach one file to each message. Attachment file size is limited to 2MB. If you need to include several files, you may do so by zipping them into a single archive.

If you forgot to attach your files to your post, please do NOT create a new thread. Instead, reply to your original message and attach the file there.

When attaching screen shots, it is best to attach an image file (.BMP, .JPG, .GIF, .PNG, etc.) or a zip file of several images, as opposed to a Word document containing the screen shots. Because Word documents are prone to viruses, many message board users will not open your Word file, therefore limiting their ability to help you.

Similarly, if you are uploading a zipped archive, you should simply create a .ZIP file and not a self-extracting .EXE as many users will not run your EXE file.
See more
See less

Mandrill changing

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    #61
    Re: Mandrill changing

    Lance, these are not using my latest updated function. Please go re-download and update. You often need to restart the WAS for it to take hold.
    Steve Wood
    See my profile on IADN

    Comment


      #62
      Re: Mandrill changing

      Steve,
      I think the problem does not lie within the data but rather within the html message that cannot get evaluate_string(html_message) done because it does not know how to handle the {{ var }} merge field part of the message.
      How do I include the merge {{ var }} in my html message allowing it to go through while still evaluate_string(html_message) the in program e.data merge { var} that are needed to be resolved? I believe this is the problem. Do I need to make my my {{ var }} global variables instead?
      Hell I am pretty confused already.

      Calyxte
      I will send this email to the email you have posted with Alpha forum.

      Here is my test code and actual data on bottom.. Here are the parts I think you need to look at, if I am missing something let me know.
      Thanks


      dim ms as p



      Mem_tbl = table.open("[PathAlias.ADB_Path]\c_members", file_rw_shared)
      query.filter = "vCh_id = Ch_Mem_Ch_Id .and. (Ch_Mem_Email_Unsubscribe = .f. .and. Ch_Mem_Lw_Or_Ch_Turnoff_Mem <> .t.) .and. date() <= Ch_Mem_Mship_Exp_Date .and. date()-3 > Ch_Mem_Include_Me_Date"
      QMem_tbl = Mem_tbl.query_create()
      Mem_tbl.fetch_first()
      while .NOT. Mem_tbl.fetch_EOF()
      vMem_Count2 = vMem_Count2 + 1

      vMem_First = alltrim(Mem_tbl.ch_mem_fname)
      vMem_Email = alltrim(Mem_tbl.ch_mem_email_address)
      vMem_ID = alltrim(Mem_tbl.ch_mem_id)


      if vMem_Count2 < vMem_TR then
      vdata = vdata + "{first: "{vmem_first}", email: "{vmem_email}", id: "{vmem_id}"{vch_ng_id_combo2}},"
      vdata = evaluate_String(vdata)
      else ' this next part provides the appropriate last line for the datasource. Notice no comma?
      vdata = vdata + "{first: "{vmem_first}", email: "{vmem_email}", id: "{vmem_id}"{vch_ng_id_combo2}}"
      vdata = evaluate_String(vdata)
      End if
      Mem_tbl.fetch_next()
      end while
      QMem_tbl.drop() ' drop query when done.
      Mem_tbl.close() 'Close Networking_group.dbf


      dataSource = <<%txt%
      [
      {vdata}]
      %txt%

      ms.dataSource = evaluate_string(dataSource)


      'Setup the data for the group email message. Can you see the merge fields for Mandrill they look like
      dim html_message as c
      html_message = <<%html%
      <html>
      <head> </head>
      <body>
      <br>
      <img src="http://lunchworks.publicvm.com/images//lunchworks_email_logo.jpg"><br/>
      Build Your Business, One Lunch At A Time.<br/>
      ---------------------------------------------------------------<br/>
      <p><p> Dear {{ first }},

      <p><p>{e.DataSubmitted.Ch_em_body}<p>


      <p><b><u>Here Are This Week's Networking Event(s).</u></b><p><br>

      {VtempHTML2}
      <b><u>What Happens Next</u></b><br><br>
      1) You will receive a LunchWorks eMail confirming that we have you signed up for that event.<br>
      2) The day before the event in the afternoon we will eMail you the details of your meeting, including the<br>
      &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;restaurant location, day, time, whom you will be networking with and their contact information.<br>
      3) Update your Business Profile if you have not already done so.<br><br><br>


      <b><u>My Control Panel</u></b><br><br>
      <table>
      <tr><td><a href="http://www.lunchworks.biz/CH_Member_Mem_Web_Edit_Form.a5w?vid={{ id }}">My Business Profile</a></td><td>&nbsp;&nbsp;&nbsp;&nbsp;See / Edit my profile.</td><td>&nbsp;&nbsp;&nbsp;&nbsp;</td></tr>
      <tr><td><a href="http://www.lunchworks.biz/CH_Member_Lunch_Participation.a5w?vid={{ id }}">My Luncheon History</a></td><td>&nbsp;&nbsp;&nbsp;&nbsp;See my luncheon history.</td><td>&nbsp;&nbsp;&nbsp;&nbsp;</td></tr>
      <tr><td><a href="http://www.lunchworks.biz/CH_Members_View_Members.a5w?vid={{ id }}">Other Members</a></td><td>&nbsp;&nbsp;&nbsp;&nbsp;See other member profiles.</td><td>&nbsp;&nbsp;&nbsp;&nbsp;</td></tr>
      <tr><td><a href="http://www.lunchworks.biz/CH_Member_Mem_Web_Unsubscribe_Form.a5w?vid={{ id }}">Unsubscribe Me</a></td><td>&nbsp;&nbsp;&nbsp;&nbsp;Remove me from receiving all future eMails.</td><td>&nbsp;&nbsp;&nbsp;&nbsp;</td></tr>
      </table><p>
      </body>
      </html>
      %html%


      ' html_message = evaluate_string(html_message) '- THIS WONT EVALUATE WITH {{ VAR }}

      ' <tr><td><a href="http://www.lunchworks.biz/CH_Member_Mem_Web_Edit_Form.a5w?vid=*|id|*">Restaurant</a></td><td>&nbsp;&nbsp;&nbsp;&nbsp;I am a restaurant</td><td>&nbsp;&nbsp;&nbsp;&nbsp;I want to provide meals for the LunchWorks events. I will update my restaurant information part of my profile so LunchWorks will know my wishes.</td></tr>
      ' <tr><td><a href="http://www.lunchworks.biz/CH_Member_Mem_Web_Edit_Form.a5w?vid=*|id|*">Membership</a></td><td>&nbsp;&nbsp;&nbsp;&nbsp;I know LunchWorks</td><td>&nbsp;&nbsp;&nbsp;&nbsp;Is free for a limited time and I want to participate in every LunchWorks networking opportunity so SIGN ME UP NOW!</td></tr>


      ' Now we setup the Mandrill email sending function.

      Dim VCh_em_subject as c = e.DataSubmitted.Ch_em_subject 'dim vng_email_rem_sub_line as c 'member weekly reminder subject line
      dim pm as p
      'dim ms as p
      'dim pResult as p


      ' * * * * * * * * * * * * TEST AREA
      TESTAREA:


      ms.send_to = "none" '"[email protected]"
      ms.from_email = "[email protected]"
      ms.from_name = "Larry B"
      ms.subject = "ANOTHER TEST This is the subject"
      ms.message_html = html_message
      dim ms.dataSource as c = evaluate_string(dataSource)

      dim pResult as p = wt_email_send_sparkpost("XXXXXXXXXXXXXXXXXXXXXXX",ms)
      if pResult.error = .t. then
      save_to_file(pResult.body + crlf(2) + pResult.json,"c:\sparkpost_error.txt")
      end if

      HERE ARE 2 DATA DUMPS WHEN CHECKING THE VARIABLE IN DEBUG MODE. THEY ARE FROM HTML_MESSAGE - NOT EVALUATED AND MS.DATASOURCE
      MS.DATASOURCE LOOKS LIKE THIS:
      [
      {first: "Larry", email: "[email protected]", id: "a1234567890", ngid1: "f3d2cd9c-9c48-454c-854a-26b5c83420e3", ngid2: "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", ngid3: "7c6b2c73-20d0-47ef-88bb-ac16188def3f"},{first: "Calyxe", email: "[email protected]", id: "eab49676-7fff-46fe-92e3-9053d6703f65", ngid1: "f3d2cd9c-9c48-454c-854a-26b5c83420e3", ngid2: "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", ngid3: "7c6b2c73-20d0-47ef-88bb-ac16188def3f"},{first: "CarolAnn", email: "[email protected]", id: "0eeff8ff-d8ec-449e-8bb8-c9dcb607277a", ngid1: "f3d2cd9c-9c48-454c-854a-26b5c83420e3", ngid2: "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", ngid3: "7c6b2c73-20d0-47ef-88bb-ac16188def3f"},{first: "david", email: "[email protected]", id: "eab49676-7fff-46fe-92e3-9053d6703f6a", ngid1: "f3d2cd9c-9c48-454c-854a-26b5c83420e3", ngid2: "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", ngid3: "7c6b2c73-20d0-47ef-88bb-ac16188def3f"},{first: "george", email: "[email protected]", id: "eab49676-7fff-46fe-92e3-9053d6703f6b", ngid1: "f3d2cd9c-9c48-454c-854a-26b5c83420e3", ngid2: "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", ngid3: "7c6b2c73-20d0-47ef-88bb-ac16188def3f"},{first: "evan", email: "[email protected]", id: "eab49676-7fff-46fe-92e3-9053d6703f6c", ngid1: "f3d2cd9c-9c48-454c-854a-26b5c83420e3", ngid2: "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", ngid3: "7c6b2c73-20d0-47ef-88bb-ac16188def3f"},{first: "susi", email: "[email protected]", id: "eab49676-7fff-46fe-92e3-9053d6703f6d", ngid1: "f3d2cd9c-9c48-454c-854a-26b5c83420e3", ngid2: "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", ngid3: "7c6b2c73-20d0-47ef-88bb-ac16188def3f"},{first: "garry", email: "[email protected]", id: "eab49676-7fff-46fe-92e3-9053d6703f6e", ngid1: "f3d2cd9c-9c48-454c-854a-26b5c83420e3", ngid2: "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", ngid3: "7c6b2c73-20d0-47ef-88bb-ac16188def3f"},{first: "kevin", email: "[email protected]", id: "eab49676-7fff-46fe-92e3-9053d6703f6f", ngid1: "f3d2cd9c-9c48-454c-854a-26b5c83420e3", ngid2: "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", ngid3: "7c6b2c73-20d0-47ef-88bb-ac16188def3f"},{first: "mary", email: "[email protected]", id: "eab49676-7fff-46fe-92e3-9053d6703f6g", ngid1: "f3d2cd9c-9c48-454c-854a-26b5c83420e3", ngid2: "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", ngid3: "7c6b2c73-20d0-47ef-88bb-ac16188def3f"},{first: "owen", email: "[email protected]", id: "0eeff8ff-d8ec-449e-8bb8-c9dcb607277b", ngid1: "f3d2cd9c-9c48-454c-854a-26b5c83420e3", ngid2: "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", ngid3: "7c6b2c73-20d0-47ef-88bb-ac16188def3f"},{first: "quick", email: "[email protected]", id: "0eeff8ff-d8ec-449e-8bb8-c9dcb607277c", ngid1: "f3d2cd9c-9c48-454c-854a-26b5c83420e3", ngid2: "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", ngid3: "7c6b2c73-20d0-47ef-88bb-ac16188def3f"},{first: "adam", email: "[email protected]", id: "0eeff8ff-d8ec-449e-8bb8-c9dcb607277d", ngid1: "f3d2cd9c-9c48-454c-854a-26b5c83420e3", ngid2: "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", ngid3: "7c6b2c73-20d0-47ef-88bb-ac16188def3f"},{first: "ziey", email: "[email protected]", id: "0eeff8ff-d8ec-449e-8bb8-c9dcb607277e", ngid1: "f3d2cd9c-9c48-454c-854a-26b5c83420e3", ngid2: "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", ngid3: "7c6b2c73-20d0-47ef-88bb-ac16188def3f"}]


      MS.MESSAGE_HTML LOOKS LIKE THIS:
      <html>
      <head> </head>
      <body>
      <br>
      <img src="http://lunchworks.publicvm.com/images//lunchworks_email_logo.jpg"><br/>
      Build Your Business, One Lunch At A Time.<br/>
      ---------------------------------------------------------------<br/>
      <p><p> Dear {{ first }},
      <p><p>{e.DataSubmitted.Ch_em_body}<p>
      <p><b><u>Here Are This Week's Networking Event(s).</u></b><p><br>
      {VtempHTML2}
      <b><u>What Happens Next</u></b><br><br>
      1) You will receive a LunchWorks eMail confirming that we have you signed up for that event.<br>
      2) The day before the event in the afternoon we will eMail you the details of your meeting, including the<br>
      &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;restaurant location, day, time, whom you will be networking with and their contact information.<br>
      3) Update your Business Profile if you have not already done so.<br><br><br>
      <b><u>My Control Panel</u></b><br><br>
      <table>
      <tr><td><a href="http://www.lunchworks.biz/CH_Member_Mem_Web_Edit_Form.a5w?vid={{ id }}">My Business Profile</a></td><td>&nbsp;&nbsp;&nbsp;&nbsp;See / Edit my profile.</td><td>&nbsp;&nbsp;&nbsp;&nbsp;</td></tr>
      <tr><td><a href="http://www.lunchworks.biz/CH_Member_Lunch_Participation.a5w?vid={{ id }}">My Luncheon History</a></td><td>&nbsp;&nbsp;&nbsp;&nbsp;See my luncheon history.</td><td>&nbsp;&nbsp;&nbsp;&nbsp;</td></tr>
      <tr><td><a href="http://www.lunchworks.biz/CH_Members_View_Members.a5w?vid={{ id }}">Other Members</a></td><td>&nbsp;&nbsp;&nbsp;&nbsp;See other member profiles.</td><td>&nbsp;&nbsp;&nbsp;&nbsp;</td></tr>
      <tr><td><a href="http://www.lunchworks.biz/CH_Member_Mem_Web_Unsubscribe_Form.a5w?vid={{ id }}">Unsubscribe Me</a></td><td>&nbsp;&nbsp;&nbsp;&nbsp;Remove me from receiving all future eMails.</td><td>&nbsp;&nbsp;&nbsp;&nbsp;</td></tr>
      </table><p>
      </body>
      </html>

      Comment


        #63
        Re: Mandrill changing

        In my Sparkpost account nothing is delayed or rejected, it says everything is delivered including the ones to me.

        Comment


          #64
          Re: Mandrill changing

          Hi Steve,
          I just downloaded and installed the newest version of the function.

          I do appreciate all your hard work.
          What was working with Mandrill does not work with sparkpost when using the message_html with merge fields and the DataSource method.
          I will attach 3 files. 2 input files and the sparkpost function error file so you can see what is going on.
          At this point I have no idea as to where its going wrong but can assure you that what I had before was working for the past 10 months with no glitches with Mandrill. Not to make you wrong, and I dont know where else to look given that my coding seems correct by me.
          Your thoughts?
          Larry
          I will attach the 3 files.
          Attached Files

          Comment


            #65
            Re: Mandrill changing

            Larry,

            All you need to do is alter your dataSource so that the email address is the first field. I made basic assumptions about the Mandrill function, that is one of them.

            {email: "[email protected]", first: "Larry", id: "a1234567890", ngid1: "f3d2cd9c-9c48-454c-854a-26b5c83420e3", ngid2: "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", ngid3: "7c6b2c73-20d0-47ef-88bb-ac16188def3f"},
            {email: "[email protected]", first: "Calyxe", id: "eab49676-7fff-46fe-92e3-9053d6703f65", ngid1: "f3d2cd9c-9c48-454c-854a-26b5c83420e3", ngid2: "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", ngid3: "7c6b2c73-20d0-47ef-88bb-ac16188def3f"}
            .....
            Steve Wood
            See my profile on IADN

            Comment


              #66
              Re: Mandrill changing

              Thank you i will give it a try and let you know.
              Perhaps this should be a part of the docs.
              Larry

              Comment


                #67
                Re: Mandrill changing

                I made those changes. email is now the first field.
                The bad or good news is that there was no error from the sparkpost error file.
                The bad news is that sparkpost control panel does not show it received anything at all and of course it does not seem like any email has been sent out either.
                Do the field names matter after that first email field?
                Any other assumptions made?
                I think after I have given this function a work out it will be ready for any newbie...
                L

                Comment


                  #68
                  Re: Mandrill changing

                  Steve,
                  Here below is the incoming ms.DataSource
                  Does there need to be a line return/carriage return to separate each record? I notice in your sample there is a line feed/carriage return or is that just the way you happen to write out the data?
                  L




                  [
                  {email: "[email protected]", first: "Larry", id: "a1234567890", ngid1: "f3d2cd9c-9c48-454c-854a-26b5c83420e3", ngid2: "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", ngid3: "7c6b2c73-20d0-47ef-88bb-ac16188def3f"},{email: "[email protected]", first: "Calyxe", id: "eab49676-7fff-46fe-92e3-9053d6703f65", ngid1: "f3d2cd9c-9c48-454c-854a-26b5c83420e3", ngid2: "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", ngid3: "7c6b2c73-20d0-47ef-88bb-ac16188def3f"},{email: "[email protected]", first: "CarolAnn", id: "0eeff8ff-d8ec-449e-8bb8-c9dcb607277a", ngid1: "f3d2cd9c-9c48-454c-854a-26b5c83420e3", ngid2: "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", ngid3: "7c6b2c73-20d0-47ef-88bb-ac16188def3f"},{email: "[email protected]", first: "david", id: "eab49676-7fff-46fe-92e3-9053d6703f6a", ngid1: "f3d2cd9c-9c48-454c-854a-26b5c83420e3", ngid2: "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", ngid3: "7c6b2c73-20d0-47ef-88bb-ac16188def3f"},{email: "[email protected]", first: "george", id: "eab49676-7fff-46fe-92e3-9053d6703f6b", ngid1: "f3d2cd9c-9c48-454c-854a-26b5c83420e3", ngid2: "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", ngid3: "7c6b2c73-20d0-47ef-88bb-ac16188def3f"},{email: "[email protected]", first: "evan", id: "eab49676-7fff-46fe-92e3-9053d6703f6c", ngid1: "f3d2cd9c-9c48-454c-854a-26b5c83420e3", ngid2: "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", ngid3: "7c6b2c73-20d0-47ef-88bb-ac16188def3f"},{email: "[email protected]", first: "susi", id: "eab49676-7fff-46fe-92e3-9053d6703f6d", ngid1: "f3d2cd9c-9c48-454c-854a-26b5c83420e3", ngid2: "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", ngid3: "7c6b2c73-20d0-47ef-88bb-ac16188def3f"},{email: "[email protected]", first: "garry", id: "eab49676-7fff-46fe-92e3-9053d6703f6e", ngid1: "f3d2cd9c-9c48-454c-854a-26b5c83420e3", ngid2: "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", ngid3: "7c6b2c73-20d0-47ef-88bb-ac16188def3f"},{email: "[email protected]", first: "kevin", id: "eab49676-7fff-46fe-92e3-9053d6703f6f", ngid1: "f3d2cd9c-9c48-454c-854a-26b5c83420e3", ngid2: "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", ngid3: "7c6b2c73-20d0-47ef-88bb-ac16188def3f"},{email: "[email protected]", first: "mary", id: "eab49676-7fff-46fe-92e3-9053d6703f6g", ngid1: "f3d2cd9c-9c48-454c-854a-26b5c83420e3", ngid2: "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", ngid3: "7c6b2c73-20d0-47ef-88bb-ac16188def3f"},{email: "[email protected]", first: "owen", id: "0eeff8ff-d8ec-449e-8bb8-c9dcb607277b", ngid1: "f3d2cd9c-9c48-454c-854a-26b5c83420e3", ngid2: "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", ngid3: "7c6b2c73-20d0-47ef-88bb-ac16188def3f"},{email: "[email protected]", first: "quick", id: "0eeff8ff-d8ec-449e-8bb8-c9dcb607277c", ngid1: "f3d2cd9c-9c48-454c-854a-26b5c83420e3", ngid2: "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", ngid3: "7c6b2c73-20d0-47ef-88bb-ac16188def3f"},{email: "[email protected]", first: "adam", id: "0eeff8ff-d8ec-449e-8bb8-c9dcb607277d", ngid1: "f3d2cd9c-9c48-454c-854a-26b5c83420e3", ngid2: "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", ngid3: "7c6b2c73-20d0-47ef-88bb-ac16188def3f"},{email: "[email protected]", first: "ziey", id: "0eeff8ff-d8ec-449e-8bb8-c9dcb607277e", ngid1: "f3d2cd9c-9c48-454c-854a-26b5c83420e3", ngid2: "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", ngid3: "7c6b2c73-20d0-47ef-88bb-ac16188def3f"}]

                  Comment


                    #69
                    Re: Mandrill changing

                    If SP says it accepted them*, then your emails made it that far. What happens after that is up to SP and you should review their logs. I look under Reports > Message Events.

                    * similar response to this:
                    { "results": { "total_rejected_recipients": 0, "total_accepted_recipients": 7, "id": "30276789534589069" } }
                    Steve Wood
                    See my profile on IADN

                    Comment


                      #70
                      Re: Mandrill changing

                      So no response from the error file is an assumption that it was accepted by Sparkpost...
                      Sparkpost does not show it received anything at all..
                      I think at this point i am in limbo..
                      :(
                      L

                      Comment


                        #71
                        Re: Mandrill changing

                        Hi Steve,
                        Ok here is the new data file. I believe exactly as requested.
                        No errors in the error file.
                        Sparkpost does not show it has received anything.
                        I added the CRLF and the data file looks good.
                        Your thoughts?
                        L


                        [
                        {email: "[email protected]", first: "Larry", id: "a1234567890", ngid1: "f3d2cd9c-9c48-454c-854a-26b5c83420e3", ngid2: "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", ngid3: "7c6b2c73-20d0-47ef-88bb-ac16188def3f"},
                        {email: "[email protected]", first: "Calyxe", id: "eab49676-7fff-46fe-92e3-9053d6703f65", ngid1: "f3d2cd9c-9c48-454c-854a-26b5c83420e3", ngid2: "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", ngid3: "7c6b2c73-20d0-47ef-88bb-ac16188def3f"},
                        {email: "[email protected]", first: "CarolAnn", id: "0eeff8ff-d8ec-449e-8bb8-c9dcb607277a", ngid1: "f3d2cd9c-9c48-454c-854a-26b5c83420e3", ngid2: "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", ngid3: "7c6b2c73-20d0-47ef-88bb-ac16188def3f"},
                        {email: "[email protected]", first: "david", id: "eab49676-7fff-46fe-92e3-9053d6703f6a", ngid1: "f3d2cd9c-9c48-454c-854a-26b5c83420e3", ngid2: "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", ngid3: "7c6b2c73-20d0-47ef-88bb-ac16188def3f"},
                        {email: "[email protected]", first: "george", id: "eab49676-7fff-46fe-92e3-9053d6703f6b", ngid1: "f3d2cd9c-9c48-454c-854a-26b5c83420e3", ngid2: "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", ngid3: "7c6b2c73-20d0-47ef-88bb-ac16188def3f"},
                        {email: "[email protected]", first: "evan", id: "eab49676-7fff-46fe-92e3-9053d6703f6c", ngid1: "f3d2cd9c-9c48-454c-854a-26b5c83420e3", ngid2: "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", ngid3: "7c6b2c73-20d0-47ef-88bb-ac16188def3f"},
                        {email: "[email protected]", first: "susi", id: "eab49676-7fff-46fe-92e3-9053d6703f6d", ngid1: "f3d2cd9c-9c48-454c-854a-26b5c83420e3", ngid2: "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", ngid3: "7c6b2c73-20d0-47ef-88bb-ac16188def3f"},
                        {email: "[email protected]", first: "garry", id: "eab49676-7fff-46fe-92e3-9053d6703f6e", ngid1: "f3d2cd9c-9c48-454c-854a-26b5c83420e3", ngid2: "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", ngid3: "7c6b2c73-20d0-47ef-88bb-ac16188def3f"},
                        {email: "[email protected]", first: "kevin", id: "eab49676-7fff-46fe-92e3-9053d6703f6f", ngid1: "f3d2cd9c-9c48-454c-854a-26b5c83420e3", ngid2: "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", ngid3: "7c6b2c73-20d0-47ef-88bb-ac16188def3f"},
                        {email: "[email protected]", first: "mary", id: "eab49676-7fff-46fe-92e3-9053d6703f6g", ngid1: "f3d2cd9c-9c48-454c-854a-26b5c83420e3", ngid2: "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", ngid3: "7c6b2c73-20d0-47ef-88bb-ac16188def3f"},
                        {email: "[email protected]", first: "owen", id: "0eeff8ff-d8ec-449e-8bb8-c9dcb607277b", ngid1: "f3d2cd9c-9c48-454c-854a-26b5c83420e3", ngid2: "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", ngid3: "7c6b2c73-20d0-47ef-88bb-ac16188def3f"},
                        {email: "[email protected]", first: "quick", id: "0eeff8ff-d8ec-449e-8bb8-c9dcb607277c", ngid1: "f3d2cd9c-9c48-454c-854a-26b5c83420e3", ngid2: "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", ngid3: "7c6b2c73-20d0-47ef-88bb-ac16188def3f"},
                        {email: "[email protected]", first: "adam", id: "0eeff8ff-d8ec-449e-8bb8-c9dcb607277d", ngid1: "f3d2cd9c-9c48-454c-854a-26b5c83420e3", ngid2: "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", ngid3: "7c6b2c73-20d0-47ef-88bb-ac16188def3f"},
                        {email: "[email protected]", first: "ziey", id: "0eeff8ff-d8ec-449e-8bb8-c9dcb607277e", ngid1: "f3d2cd9c-9c48-454c-854a-26b5c83420e3", ngid2: "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", ngid3: "7c6b2c73-20d0-47ef-88bb-ac16188def3f"}
                        ]

                        Comment


                          #72
                          Re: Mandrill changing

                          What do you get back from SP when you send the request? Grab the response as pResult.body. It should look similar to this:

                          { "results": { "total_rejected_recipients": 0, "total_accepted_recipients": 7, "id": "30276789534589069" } }

                          If the response says it received the request, then it received the request and there is nothing more to do on our side. I doubt that it shows instantly on SP logs and I don't know what exactly you are looking at when you go to their site.
                          Steve Wood
                          See my profile on IADN

                          Comment


                            #73
                            Re: Mandrill changing

                            { "errors": [ { "message": "invalid data format\/type", "description": "Problems parsing request as json", "code": "1300" } ] }

                            {
                            "recipients":[
                            { "address" : { "email" : "[email protected]"}, "substitution_data" : { "first" : "Larry", "id" : "a1234567890", "ngid1" : "f3d2cd9c-9c48-454c-854a-26b5c83420e3", "ngid2" : "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", "ngid3" : "7c6b2c73-20d0-47ef-88bb-ac16188def3f" }},
                            { "address" : { "email" : "[email protected]"}, "substitution_data" : { "first" : "Calyxe", "id" : "eab49676-7fff-46fe-92e3-9053d6703f65", "ngid1" : "f3d2cd9c-9c48-454c-854a-26b5c83420e3", "ngid2" : "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", "ngid3" : "7c6b2c73-20d0-47ef-88bb-ac16188def3f" }},
                            { "address" : { "email" : "[email protected]"}, "substitution_data" : { "first" : "CarolAnn", "id" : "0eeff8ff-d8ec-449e-8bb8-c9dcb607277a", "ngid1" : "f3d2cd9c-9c48-454c-854a-26b5c83420e3", "ngid2" : "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", "ngid3" : "7c6b2c73-20d0-47ef-88bb-ac16188def3f" }},
                            { "address" : { "email" : "[email protected]"}, "substitution_data" : { "first" : "david", "id" : "eab49676-7fff-46fe-92e3-9053d6703f6a", "ngid1" : "f3d2cd9c-9c48-454c-854a-26b5c83420e3", "ngid2" : "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", "ngid3" : "7c6b2c73-20d0-47ef-88bb-ac16188def3f" }},
                            { "address" : { "email" : "[email protected]"}, "substitution_data" : { "first" : "george", "id" : "eab49676-7fff-46fe-92e3-9053d6703f6b", "ngid1" : "f3d2cd9c-9c48-454c-854a-26b5c83420e3", "ngid2" : "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", "ngid3" : "7c6b2c73-20d0-47ef-88bb-ac16188def3f" }},
                            { "address" : { "email" : "[email protected]"}, "substitution_data" : { "first" : "evan", "id" : "eab49676-7fff-46fe-92e3-9053d6703f6c", "ngid1" : "f3d2cd9c-9c48-454c-854a-26b5c83420e3", "ngid2" : "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", "ngid3" : "7c6b2c73-20d0-47ef-88bb-ac16188def3f" }},
                            { "address" : { "email" : "[email protected]"}, "substitution_data" : { "first" : "susi", "id" : "eab49676-7fff-46fe-92e3-9053d6703f6d", "ngid1" : "f3d2cd9c-9c48-454c-854a-26b5c83420e3", "ngid2" : "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", "ngid3" : "7c6b2c73-20d0-47ef-88bb-ac16188def3f" }},
                            { "address" : { "email" : "[email protected]"}, "substitution_data" : { "first" : "garry", "id" : "eab49676-7fff-46fe-92e3-9053d6703f6e", "ngid1" : "f3d2cd9c-9c48-454c-854a-26b5c83420e3", "ngid2" : "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", "ngid3" : "7c6b2c73-20d0-47ef-88bb-ac16188def3f" }},
                            { "address" : { "email" : "[email protected]"}, "substitution_data" : { "first" : "kevin", "id" : "eab49676-7fff-46fe-92e3-9053d6703f6f", "ngid1" : "f3d2cd9c-9c48-454c-854a-26b5c83420e3", "ngid2" : "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", "ngid3" : "7c6b2c73-20d0-47ef-88bb-ac16188def3f" }},
                            { "address" : { "email" : "[email protected]"}, "substitution_data" : { "first" : "mary", "id" : "eab49676-7fff-46fe-92e3-9053d6703f6g", "ngid1" : "f3d2cd9c-9c48-454c-854a-26b5c83420e3", "ngid2" : "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", "ngid3" : "7c6b2c73-20d0-47ef-88bb-ac16188def3f" }},
                            { "address" : { "email" : "[email protected]"}, "substitution_data" : { "first" : "owen", "id" : "0eeff8ff-d8ec-449e-8bb8-c9dcb607277b", "ngid1" : "f3d2cd9c-9c48-454c-854a-26b5c83420e3", "ngid2" : "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", "ngid3" : "7c6b2c73-20d0-47ef-88bb-ac16188def3f" }},
                            { "address" : { "email" : "[email protected]"}, "substitution_data" : { "first" : "quick", "id" : "0eeff8ff-d8ec-449e-8bb8-c9dcb607277c", "ngid1" : "f3d2cd9c-9c48-454c-854a-26b5c83420e3", "ngid2" : "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", "ngid3" : "7c6b2c73-20d0-47ef-88bb-ac16188def3f" }},
                            { "address" : { "email" : "[email protected]"}, "substitution_data" : { "first" : "adam", "id" : "0eeff8ff-d8ec-449e-8bb8-c9dcb607277d", "ngid1" : "f3d2cd9c-9c48-454c-854a-26b5c83420e3", "ngid2" : "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", "ngid3" : "7c6b2c73-20d0-47ef-88bb-ac16188def3f" }},
                            { "address" : { "email" : "[email protected]"}, "substitution_data" : { "first" : "ziey", "id" : "0eeff8ff-d8ec-449e-8bb8-c9dcb607277e", "ngid1" : "f3d2cd9c-9c48-454c-854a-26b5c83420e3", "ngid2" : "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", "ngid3" : "7c6b2c73-20d0-47ef-88bb-ac16188def3f"} }
                            ],
                            "content":{
                            "from":{
                            "name":"Larry B",
                            "email":"[email protected]"
                            },
                            "subject":"ANOTHER TEST This is the subject",
                            "text":"",
                            "html":"" <html>"+chr(13)+chr(10)+" <head> </head>"+chr(13)+chr(10)+" <body>"+chr(13)+chr(10)+" <br>"+chr(13)+chr(10)+" <img src="+chr(34)+"http://lunchworks.publicvm.com/images//lunchworks_email_logo.jpg"+chr(34)+"><br/>"+chr(13)+chr(10)+" Build Your Business, One Lunch At A Time.<br/>"+chr(13)+chr(10)+" ---------------------------------------------------------------<br/>"+chr(13)+chr(10)+" <p><p> Dear {{ first }},"+chr(13)+chr(10)+" <p><p>General reminder email<p>"+chr(13)+chr(10)+" <p><b><u>Here Are This Week's Networking Event(s).</u></b><p><br>"+chr(13)+chr(10)+" West Side Highway - Monday at 12:30 PM<br> "+chr(13)+chr(10)+" Network contact is: Mark Glazier<br>"+chr(13)+chr(10)+" Phone: 6097229316 <br>"+chr(13)+chr(10)+" eMail: [email protected] <br><br>"+chr(13)+chr(10)+" <b><u>What You Do</b></u><br><br>"+chr(13)+chr(10)+" <a href="+chr(34)+"http://www.lunchworks.biz/CH_Member_Mem_Web_Include_Me_Form.a5w?vid={{ id }}&ngid=f3d2cd9c-9c48-454c-854a-26b5c83420e3"+chr(34)+">INCLUDE ME in this awesome networking event!</a> <br><br><br><br> "+chr(13)+chr(10)+" East Side Highway - Monday at 11:30<br> "+chr(13)+chr(10)+" Network contact is: <br>"+chr(13)+chr(10)+" Phone: <br>"+chr(13)+chr(10)+" eMail: [email protected] <br><br>"+chr(13)+chr(10)+" <b><u>What You Do</b></u><br><br>"+chr(13)+chr(10)+" <a href="+chr(34)+"http://www.lunchworks.biz/CH_Member_Mem_Web_Include_Me_Form.a5w?vid={{ id }}&ngid=88f18406-c7c1-4e00-ba0a-f21c2ecddc0e"+chr(34)+">INCLUDE ME in this awesome networking event!</a> <br><br><br><br> "+chr(13)+chr(10)+" Northeast Heights - at <br> "+chr(13)+chr(10)+" Network contact is: Mark Glazier<br>"+chr(13)+chr(10)+" Phone: (609) 722-9999 <br>"+chr(13)+chr(10)+" eMail: [email protected] <br><br>"+chr(13)+chr(10)+" <b><u>What You Do</b></u><br><br>"+chr(13)+chr(10)+" <a href="+chr(34)+"http://www.lunchworks.biz/CH_Member_Mem_Web_Include_Me_Form.a5w?vid={{ id }}&ngid=7c6b2c73-20d0-47ef-88bb-ac16188def3f"+chr(34)+">INCLUDE ME in this awesome networking event!</a> <br><br><br><br> "+chr(13)+chr(10)+" "+chr(13)+chr(10)+" <b><u>What Happens Next</u></b><br><br>"+chr(13)+chr(10)+" 1) You will receive a LunchWorks eMail confirming that we have you signed up for that event.<br>"+chr(13)+chr(10)+" 2) The day before the event in the afternoon we will eMail you the details of your meeting, including the<br>"+chr(13)+chr(10)+" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;restaurant location, day, time, whom you will be networking with and their contact information.<br>"+chr(13)+chr(10)+" 3) Update your Business Profile if you have not already done so.<br><br><br>"+chr(13)+chr(10)+" <b><u>My Control Panel</u></b><br><br>"+chr(13)+chr(10)+" <table>"+chr(13)+chr(10)+" <tr><td><a href="+chr(34)+"http://www.lunchworks.biz/CH_Member_Mem_Web_Edit_Form.a5w?vid={{ id }}"+chr(34)+">My Business Profile</a></td><td>&nbsp;&nbsp;&nbsp;&nbsp;See / Edit my profile.</td><td>&nbsp;&nbsp;&nbsp;&nbsp;</td></tr>"+chr(13)+chr(10)+" <tr><td><a href="+chr(34)+"http://www.lunchworks.biz/CH_Member_Lunch_Participation.a5w?vid={{ id }}"+chr(34)+">My Luncheon History</a></td><td>&nbsp;&nbsp;&nbsp;&nbsp;See my luncheon history.</td><td>&nbsp;&nbsp;&nbsp;&nbsp;</td></tr>"+chr(13)+chr(10)+" <tr><td><a href="+chr(34)+"http://www.lunchworks.biz/CH_Members_View_Members.a5w?vid={{ id }}"+chr(34)+">Other Members</a></td><td>&nbsp;&nbsp;&nbsp;&nbsp;See other member profiles.</td><td>&nbsp;&nbsp;&nbsp;&nbsp;</td></tr>"+chr(13)+chr(10)+" <tr><td><a href="+chr(34)+"http://www.lunchworks.biz/CH_Member_Mem_Web_Unsubscribe_Form.a5w?vid={{ id }}"+chr(34)+">Unsubscribe Me</a></td><td>&nbsp;&nbsp;&nbsp;&nbsp;Remove me from receiving all future eMails.</td><td>&nbsp;&nbsp;&nbsp;&nbsp;</td></tr> "+chr(13)+chr(10)+" </table><p>"+chr(13)+chr(10)+" </body>"+chr(13)+chr(10)+" </html>"+chr(13)+chr(10)+" "",
                            "attachments":[

                            ]
                            }
                            }

                            Comment


                              #74
                              Re: Mandrill changing

                              Larry,

                              The problem is 100% with your message_html content. That is NOT valid HTML. It is some html and a bunch of xbasic. There are no double quote marks in html, there are no chr(x) in html or plus signs, etc. The {{}} are ok because SparkPost is going to replace those with your merge values.

                              To confirm this all works I stripped out your "html" and ran the exact json and it sent all of the email (to me) just fine.
                              Steve Wood
                              See my profile on IADN

                              Comment


                                #75
                                Re: Mandrill changing

                                Steve,
                                I see your point...
                                I removed the quote() funtion from the html message and this is the latest error. You will notice the html finally does look like html.. i will continue to work on it.
                                Do you think the problem is that I got data fields in the json that I don't have any fields for in the HTML merge document?
                                L

                                ----------------------
                                { "errors": [ { "message": "invalid data format\/type", "description": "Problems parsing request as json", "code": "1300" } ] }

                                {
                                "recipients":[
                                { "address" : { "email" : "[email protected]"}, "substitution_data" : { "first" : "Larry", "id" : "a1234567890", "ngid1" : "f3d2cd9c-9c48-454c-854a-26b5c83420e3", "ngid2" : "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", "ngid3" : "7c6b2c73-20d0-47ef-88bb-ac16188def3f" }},
                                { "address" : { "email" : "[email protected]"}, "substitution_data" : { "first" : "Calyxe", "id" : "eab49676-7fff-46fe-92e3-9053d6703f65", "ngid1" : "f3d2cd9c-9c48-454c-854a-26b5c83420e3", "ngid2" : "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", "ngid3" : "7c6b2c73-20d0-47ef-88bb-ac16188def3f" }},
                                { "address" : { "email" : "[email protected]"}, "substitution_data" : { "first" : "CarolAnn", "id" : "0eeff8ff-d8ec-449e-8bb8-c9dcb607277a", "ngid1" : "f3d2cd9c-9c48-454c-854a-26b5c83420e3", "ngid2" : "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", "ngid3" : "7c6b2c73-20d0-47ef-88bb-ac16188def3f" }},
                                { "address" : { "email" : "[email protected]"}, "substitution_data" : { "first" : "david", "id" : "eab49676-7fff-46fe-92e3-9053d6703f6a", "ngid1" : "f3d2cd9c-9c48-454c-854a-26b5c83420e3", "ngid2" : "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", "ngid3" : "7c6b2c73-20d0-47ef-88bb-ac16188def3f" }},
                                { "address" : { "email" : "[email protected]"}, "substitution_data" : { "first" : "george", "id" : "eab49676-7fff-46fe-92e3-9053d6703f6b", "ngid1" : "f3d2cd9c-9c48-454c-854a-26b5c83420e3", "ngid2" : "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", "ngid3" : "7c6b2c73-20d0-47ef-88bb-ac16188def3f" }},
                                { "address" : { "email" : "[email protected]"}, "substitution_data" : { "first" : "evan", "id" : "eab49676-7fff-46fe-92e3-9053d6703f6c", "ngid1" : "f3d2cd9c-9c48-454c-854a-26b5c83420e3", "ngid2" : "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", "ngid3" : "7c6b2c73-20d0-47ef-88bb-ac16188def3f" }},
                                { "address" : { "email" : "[email protected]"}, "substitution_data" : { "first" : "susi", "id" : "eab49676-7fff-46fe-92e3-9053d6703f6d", "ngid1" : "f3d2cd9c-9c48-454c-854a-26b5c83420e3", "ngid2" : "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", "ngid3" : "7c6b2c73-20d0-47ef-88bb-ac16188def3f" }},
                                { "address" : { "email" : "[email protected]"}, "substitution_data" : { "first" : "garry", "id" : "eab49676-7fff-46fe-92e3-9053d6703f6e", "ngid1" : "f3d2cd9c-9c48-454c-854a-26b5c83420e3", "ngid2" : "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", "ngid3" : "7c6b2c73-20d0-47ef-88bb-ac16188def3f" }},
                                { "address" : { "email" : "[email protected]"}, "substitution_data" : { "first" : "kevin", "id" : "eab49676-7fff-46fe-92e3-9053d6703f6f", "ngid1" : "f3d2cd9c-9c48-454c-854a-26b5c83420e3", "ngid2" : "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", "ngid3" : "7c6b2c73-20d0-47ef-88bb-ac16188def3f" }},
                                { "address" : { "email" : "[email protected]"}, "substitution_data" : { "first" : "mary", "id" : "eab49676-7fff-46fe-92e3-9053d6703f6g", "ngid1" : "f3d2cd9c-9c48-454c-854a-26b5c83420e3", "ngid2" : "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", "ngid3" : "7c6b2c73-20d0-47ef-88bb-ac16188def3f" }},
                                { "address" : { "email" : "[email protected]"}, "substitution_data" : { "first" : "owen", "id" : "0eeff8ff-d8ec-449e-8bb8-c9dcb607277b", "ngid1" : "f3d2cd9c-9c48-454c-854a-26b5c83420e3", "ngid2" : "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", "ngid3" : "7c6b2c73-20d0-47ef-88bb-ac16188def3f" }},
                                { "address" : { "email" : "[email protected]"}, "substitution_data" : { "first" : "quick", "id" : "0eeff8ff-d8ec-449e-8bb8-c9dcb607277c", "ngid1" : "f3d2cd9c-9c48-454c-854a-26b5c83420e3", "ngid2" : "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", "ngid3" : "7c6b2c73-20d0-47ef-88bb-ac16188def3f" }},
                                { "address" : { "email" : "[email protected]"}, "substitution_data" : { "first" : "adam", "id" : "0eeff8ff-d8ec-449e-8bb8-c9dcb607277d", "ngid1" : "f3d2cd9c-9c48-454c-854a-26b5c83420e3", "ngid2" : "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", "ngid3" : "7c6b2c73-20d0-47ef-88bb-ac16188def3f" }},
                                { "address" : { "email" : "[email protected]"}, "substitution_data" : { "first" : "ziey", "id" : "0eeff8ff-d8ec-449e-8bb8-c9dcb607277e", "ngid1" : "f3d2cd9c-9c48-454c-854a-26b5c83420e3", "ngid2" : "88f18406-c7c1-4e00-ba0a-f21c2ecddc0e", "ngid3" : "7c6b2c73-20d0-47ef-88bb-ac16188def3f"} }
                                ],
                                "content":{
                                "from":{
                                "name":"Larry B",
                                "email":"[email protected]"
                                },
                                "subject":"ANOTHER TEST This is the subject",
                                "text":"",
                                "html":" <html>
                                <head> </head>
                                <body>
                                <br>
                                <img src="http://lunchworks.publicvm.com/images//lunchworks_email_logo.jpg"><br/>
                                Build Your Business, One Lunch At A Time.<br/>
                                ---------------------------------------------------------------<br/>
                                <p><p> Dear {{ first }},
                                <p><p>General reminder email<p>
                                <p><b><u>Here Are This Week's Networking Event(s).</u></b><p><br>
                                West Side Highway - Monday at 12:30 PM<br>
                                Network contact is: Mark Glazier<br>
                                Phone: 6097229316 <br>
                                eMail: [email protected] <br><br>
                                <b><u>What You Do</b></u><br><br>
                                <a href="http://www.lunchworks.biz/CH_Member_Mem_Web_Include_Me_Form.a5w?vid={{ id }}&ngid=f3d2cd9c-9c48-454c-854a-26b5c83420e3">INCLUDE ME in this awesome networking event!</a> <br><br><br><br>
                                East Side Highway - Monday at 11:30<br>
                                Network contact is: <br>
                                Phone: <br>
                                eMail: [email protected] <br><br>
                                <b><u>What You Do</b></u><br><br>
                                <a href="http://www.lunchworks.biz/CH_Member_Mem_Web_Include_Me_Form.a5w?vid={{ id }}&ngid=88f18406-c7c1-4e00-ba0a-f21c2ecddc0e">INCLUDE ME in this awesome networking event!</a> <br><br><br><br>
                                Northeast Heights - at <br>
                                Network contact is: Mark Glazier<br>
                                Phone: (609) 722-9999 <br>
                                eMail: [email protected] <br><br>
                                <b><u>What You Do</b></u><br><br>
                                <a href="http://www.lunchworks.biz/CH_Member_Mem_Web_Include_Me_Form.a5w?vid={{ id }}&ngid=7c6b2c73-20d0-47ef-88bb-ac16188def3f">INCLUDE ME in this awesome networking event!</a> <br><br><br><br>

                                <b><u>What Happens Next</u></b><br><br>
                                1) You will receive a LunchWorks eMail confirming that we have you signed up for that event.<br>
                                2) The day before the event in the afternoon we will eMail you the details of your meeting, including the<br>
                                &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;restaurant location, day, time, whom you will be networking with and their contact information.<br>
                                3) Update your Business Profile if you have not already done so.<br><br><br>
                                <b><u>My Control Panel</u></b><br><br>
                                <table>
                                <tr><td><a href="http://www.lunchworks.biz/CH_Member_Mem_Web_Edit_Form.a5w?vid={{ id }}">My Business Profile</a></td><td>&nbsp;&nbsp;&nbsp;&nbsp;See / Edit my profile.</td><td>&nbsp;&nbsp;&nbsp;&nbsp;</td></tr>
                                <tr><td><a href="http://www.lunchworks.biz/CH_Member_Lunch_Participation.a5w?vid={{ id }}">My Luncheon History</a></td><td>&nbsp;&nbsp;&nbsp;&nbsp;See my luncheon history.</td><td>&nbsp;&nbsp;&nbsp;&nbsp;</td></tr>
                                <tr><td><a href="http://www.lunchworks.biz/CH_Members_View_Members.a5w?vid={{ id }}">Other Members</a></td><td>&nbsp;&nbsp;&nbsp;&nbsp;See other member profiles.</td><td>&nbsp;&nbsp;&nbsp;&nbsp;</td></tr>
                                <tr><td><a href="http://www.lunchworks.biz/CH_Member_Mem_Web_Unsubscribe_Form.a5w?vid={{ id }}">Unsubscribe Me</a></td><td>&nbsp;&nbsp;&nbsp;&nbsp;Remove me from receiving all future eMails.</td><td>&nbsp;&nbsp;&nbsp;&nbsp;</td></tr>
                                </table><p>
                                </body>
                                </html>
                                ",
                                "attachments":[

                                ]
                                }
                                }

                                Comment

                                Working...
                                X