+ Reply to Thread
Results 1 to 7 of 7

Emailing Files as Attachments in Outlook

  1. #1
    Forum Contributor myobreportguru's Avatar
    Join Date
    09-18-2012
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2016
    Posts
    231

    Emailing Files as Attachments in Outlook

    Hi

    I have a spreadsheet and in column A there is the paths to multiple folders. In those folders there are multiple files. In column B next to each path there is an email address I would like to email those files to as attachments. I think I would like the emails to go with only one file attached until all the files have been emailed and then on to the next folder and its files. The files in each folder changes every week and not all folders have files in them all the time. Windows 10 sometimes puts a file in the folders called thumbs.db. I never want this file emailed. The subject line can be something generic like "auto entry". The body doesn't need anything in it at all. Is it possible to get some code to do this for me. Many thanks in advance.

    Regards
    John

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Emailing Files as Attachments in Outlook

    .
    Everything email from the Email Guru : https://www.rondebruin.nl/win/s1/outlook/mail.htm

  3. #3
    Forum Contributor myobreportguru's Avatar
    Join Date
    09-18-2012
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2016
    Posts
    231

    Re: Emailing Files as Attachments in Outlook

    Thanks for your reply. I can't quite see in the list the link that will do quite what I want. I've had a look at most of them. Some more pointers might help. Thanks.

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Emailing Files as Attachments in Outlook

    .
    Here is a start towards your goal :

    Please Login or Register  to view this content.
    The above, when the FileDialog window opens, will allow you to select one file at a time, or multiple files at once.
    Attached Files Attached Files

  5. #5
    Forum Contributor myobreportguru's Avatar
    Join Date
    09-18-2012
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2016
    Posts
    231

    Re: Emailing Files as Attachments in Outlook

    I would be happy to move this to commercial if you can help me further. I will upload my spreadsheet so you can see it. As stated in my original email column A has the path to the various folders while column B has the email address for each folder.
    Attached Files Attached Files

  6. #6
    Forum Contributor myobreportguru's Avatar
    Join Date
    09-18-2012
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2016
    Posts
    231

    Re: Emailing Files as Attachments in Outlook

    I have found the solution to my problem. Please accept my thanks for responding to my question.

  7. #7
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Emailing Files as Attachments in Outlook

    .
    Glad you found your answer. You are welcome.

+ 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. Save outlook attachments and rename/append files with identifier from subject line
    By XLnExcel in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-18-2015, 12:49 PM
  2. Extract and rename batch attachments from saved outlook files on desktop.
    By entice in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 03-01-2011, 11:49 PM
  3. Emailing attachments via Excel
    By alka5eltzer in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-10-2009, 08:02 PM
  4. Emailing attachments macro
    By jat82nd in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 08-27-2007, 06:29 PM
  5. Macro for emailing attachments through Outlook
    By jat82nd in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-17-2007, 07:52 PM
  6. [SOLVED] Opening Microsoft Outlook attachments from saved .msg files
    By Rich in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-19-2006, 05:15 AM
  7. [SOLVED] Excel attachments open in outlook 2002 as TMP files
    By Kevin Dickson in forum Excel General
    Replies: 1
    Last Post: 07-15-2005, 11:05 PM

Tags for this Thread

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