Consulting

Page 2 of 2 FirstFirst 1 2
Results 21 to 23 of 23

Thread: Solved: Utilizing VBA in an Outlook Rule

  1. #21
    VBAX Master Killian's Avatar
    Joined
    Nov 2004
    Location
    London
    Posts
    1,132
    Location
    Hi Ross

    the text file was bought back as a result of the filesearch as object "ts" and as I read back through my own code I notice with some embarrassment that the line[VBA]Set ts = Nothing[/VBA] is conspicuous by it's absence. No great disaster since when the routine ends, the reference would be released anyway, but if you want to kill the file, you'll have to set that reference to nothing first.
    K :-)

  2. #22
    Killian,


    As I expected, you came thru for me again. That accomplished the task.

    Thanks Again

    Ross

  3. #23
    Ok, I thought it was all good, but now an instance of Excel is staying open. Same deal as before, where the application isn't actually open, but if I look in the processess tab I see it.

    WHen I run the process once it works fine, the second time around I get a message that the data source for the word mail merge doc is open.



    Please Help,



    Ross

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •