Search results

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...

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...

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...

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

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...

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

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...

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