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, 20, 2020 at 11:50 PM EST.

Please help.VBA add a contact sample in MS accesss

Occasional Contributor

Please help.VBA add a contact sample in MS accesss

i cant seem to get the call working. anyone have a sample adding and deleting a conctact  in  ms access.



objHTTP.Open "POST", "", False, APIkey & MyUserName, MyPassword

all i get is this

    "error_message":"The Mashery account associated with this request is not active, or an invalid API key was used."

Honored Contributor

Re: Please help.VBA add a contact sample in MS accesss



In this case, the issues that you are running into is because you are attempting to use Basic authentication with the Constant Contact V2 API. With our V2 API, we specifically only support using OAuth as a method for authenticating your requests. You can implement this by getting an access token and then adding this header to your HTTP request:

Authorization: Bearer ACCESS_TOKEN

 In order to get an access token, you can follow the directions for a single-user integration here:


If you have any follow-up questions, please feel free to reply in this thread!


Best Regards,

Elijah G.
API Support Engineer
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