Consulting

Results 1 to 2 of 2

Thread: Outlook Overriding Attachment

  1. #1
    VBAX Newbie
    Joined
    Mar 2020
    Posts
    5
    Location

    Outlook Overriding Attachment

    I have some code in an Access database that creates an Outlook email message with 2 attachments. The problem I'm running into is Outlook is overriding one of my attachments (a PowerPoint file) with some saved version of a previous email draft that has since been deleted completely. I cannot find anywhere in my database code that would cause this, and I've tried clearing the Outlook cache to no avail. I'm wondering if anyone has run into this problem in the past? I'm kind of stuck and have to have that PowerPoint file included.

  2. #2
    Without seeing the code one can only guess, but ensure that you include code remove any existing attachments before adding new ones. e.g.

    For i = olItem.Attachments.Count To 1 Step -1
          olItem.Attachments.Remove (i)
    Next i
    Graham Mayor - MS MVP (Word) 2002-2019
    Visit my web site for more programming tips and ready made processes
    http://www.gmayor.com

Tags for this Thread

Posting Permissions

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