Search results

  1. B

    query outlook using vba

    unfortunately I need to use late binding as it has several users and I can never be sure what version of outlook they use I will give it a try and see how I go I got the guy who looks after outlook 365 for this company to clean up and archive outlook items hes also set up some automatic...
  2. B

    query outlook using vba

    this is how I could supply a comma delimted array of job numbers to delete Public Sub DeleteScheduledJob(ByVal argSubject As String, MailName As String) dim myarray myarray=split(argSubject,",") from here I am lost as to how to use the array hope this is making sense to you again-thanks for...
  3. B

    query outlook using vba

    heres the sub I use Public Sub DeleteScheduledJob(ByVal argSubject As String, MailName As String) 'the job number I delete is supplied in argSubject Dim OApp As Object Dim oNameSpace As Object Dim oApptItem As Object Dim oFolder As Object Dim oMeetingoApptItem As Object...
  4. B

    query outlook using vba

    I could pass a string array to outlook-delimted by what ever outlook would recognise of course to build the array would require looping through the recordset-but that happens very quickly using vba within access. what how would I pass that to outlook to process
  5. B

    query outlook using vba

    Thanks Diane I am not sure about the losing count- I loop through a recordset in an access db and delete one record in outlook for each loop in the database.when I first started it took outlook maybe a few secs per record,and all up maybe 1 minute for the script to complete now-its 10mins and...
  6. B

    query outlook using vba

    Thanks Diane if I understand this correctly-that gets all items between dates,then loops through each item checking for the string value passed ? where did you set your tStart in this code and how would the sfilter look with the tStart Thanks for your help
  7. B

    query outlook using vba

    Is it possible to search outlook using a query in a vba script .I have a 3 calendars set up where I write to outlook and insert delivery job numbers and some information pertaining to the job as appointments I would like to clear the calendar of that job number entry once the delivery has been...
  8. B

    outlook view control

    Does anybody know how to set the folder property using vba for an outlook view control embedded into a ms access form.I can get it to work using "calendar",but want it to show a non default calendar any help much appreciated
Top