+ Reply to Thread
Results 1 to 2 of 2

Attach File to Outlook Based on Partial Criteria file name

  1. #1
    Registered User
    Join Date
    04-29-2014
    Location
    California, USA
    MS-Off Ver
    Excel 2013
    Posts
    9

    Question Attach File to Outlook Based on Partial Criteria file name

    Dear VBA Gurus, I've been out of the VBA game for many years and having great difficulty...

    In the attached, column AA, is the partial name of the file it's trying to attach (aka File Criteria Name), it's trying to find the file that contains the partial criteria name "Appleseed".

    I have no idea how to incorporate this name wildcard name loop into the existing codes by the famous "Ron".

    Please help, thank you..

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Attach File to Outlook Based on Partial Criteria file name

    altered your loop
    seems to works in test file

    Please Login or Register  to view this content.
    Last edited by humdingaling; 04-09-2019 at 05:13 AM. Reason: added strSearch
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Outlook vba attach files (max no. of attachement 9) based on file name
    By lynnsong986 in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 06-06-2017, 12:31 PM
  2. [SOLVED] run-timer error 438 trying to attach file to outlook
    By elfor in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 06-01-2017, 06:20 AM
  3. vba to convert sheet to PDF file and attach it to outlook
    By hassan khansa in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-04-2016, 10:28 AM
  4. Attach file and send in outlook
    By mohansingh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-31-2015, 12:18 PM
  5. Attach last saved file outlook/add this to quick step in Outlook
    By Nravota in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 06-25-2015, 06:25 AM
  6. I need VBA to save file and attach file to email based on conditional statements
    By jcrowe31 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-01-2014, 09:41 AM
  7. Macro to attach the file to Outlook from excel
    By Kiran Kurapati in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-07-2014, 08:52 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1