+ Reply to Thread
Results 1 to 2 of 2

Email every file in folder

  1. #1
    Forum Contributor
    Join Date
    USA, California
    MS-Off Ver
    Excel 2007

    Email every file in folder

    I have a macro that will email a file that I specify. However I want to email one at a time pictures that are in a folder. The names are variable. Is there a way to put in a list into a spreadsheet the name of every file in the folder in a workbook? If I can do that then I can use a for step loop to go down the list for the file names it needs.

    For the purposes of this project lets say the directory is C:\Documents and Settings\Randell\My Documents\My Pictures\
    Last edited by randell.graybill; 10-16-2010 at 10:28 PM.

  2. #2
    Forum Expert Domski's Avatar
    Join Date
    A galaxy far, far away
    MS-Off Ver
    Darth Office 2010

    Re: Email every file in folder

    This will list the contents of a folder to the active worksheet:

    Please Login or Register  to view this content.

    Last edited by Domski; 10-15-2010 at 05:25 AM. Reason: Misread question
    "May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."

    Use code tags when posting your VBA code: [code] Your code here [/code]

    Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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