
We have been working on populating the CRM with all of our meetings. Unfortunately we seem to have encountered an issue when adding a meeting which is entered as a recurring event in Outlook. When I tried to link the series to the relevant company through the calendar invite in Outlook, it seems to have added each meeting (which occur monthly) to the database multiple times, with different owners, despite the fact that the meeting is only in the calendar in Outlook once each month.
Do you have any suggestions as to how we can fix this? Is there a better way to add recurring events?
*This post is locked for comments
I have the same question (0)Thanks for the good response.
I would like to delete records in a table, how to to that?
so this is my script, but then I dont know how to execute it.
'Create a new connection
Set pConnection = CreateObject("ADODB.Connection")
'Open the connection to the database. Change these values:
Call pConnection.Open("DSN=CrystalCAPL", "sa", "J#Yc0e#gLe")
'Build a string containing your SQL Select Statement
sSQL = "DELETE FROM Nebula_AP_IM"