+ Reply to Thread
Results 1 to 3 of 3

Body of email to include names of attached files

  1. #1
    Forum Contributor
    Join Date
    11-23-2004
    Location
    Bristol
    MS-Off Ver
    2016
    Posts
    225

    Body of email to include names of attached files

    Hi all, im having difficulty on adding the names of the attached files into the body of an email created by the following code.
    It attaches files without any problems on Excel 2003 onwards but want to include into the body of the email the filenames of files attached.

    Please Login or Register  to view this content.
    It takes its list of files to attach from an array say 20 files including their paths and produces an email with all the files attached.
    As well as the message produced by the Body part in the code, Im unsure how to make it add each filename into the body when it loops to add the files.

    Any help is much appreciated.

  2. #2
    Forum Contributor
    Join Date
    11-23-2004
    Location
    Bristol
    MS-Off Ver
    2016
    Posts
    225

    Re: Body of email to include names of attached files

    To all who's been looking to attach files to an email and want to include into the body of the email the filenames of all attached files, I managed to solve my own question as I could not locate anywhere on the web on how to do it.

    Please Login or Register  to view this content.
    The items in bold are the items modified between both posts of this query.

    Enjoy

  3. #3
    Forum Contributor
    Join Date
    11-23-2004
    Location
    Bristol
    MS-Off Ver
    2016
    Posts
    225

    Re: Body of email to include names of attached files

    Hi everybody, the below is the code I am now using which works without error - It adds files to an email and lists each file in turn and allows you to format any text you would like to add in the body of the email, I could not find all of this in 1 piece of code so am happy to share on Excel Forum the only place it deserves to be.

    Please Login or Register  to view this content.
    Copy into a module within a new excel file, add the 3 pieces of info and enjoy.

+ 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. Looping through email body to include all records in query in Access.
    By SGT in forum Access Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2015, 09:39 AM
  2. [SOLVED] Change code to include picture in body of email
    By ExcelFailure in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-05-2013, 01:22 PM
  3. Send email integrating cell data into Subject and Body, with attached invoice
    By KarBar110 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-08-2012, 05:36 PM
  4. VBA outlook - Include sheet4 in body of the email
    By xatomicx in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-03-2010, 01:06 PM
  5. Adding text to body of email with workbook attached.
    By aph in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-05-2005, 11:11 AM

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