Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jan 2004
    Location
    Melbourne, Fl USA
    Posts
    123
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Email all Workbooks in a folder (2003 sp2)

    I have a number of workbooks in a folder - one for each person in our group. I need to be able to email each workbook (as an attachment) to the appropriate person on a monthly basis...i.e. file A to Agent A, file B to Agent B, etc. I've seen how to mail each worksheet in a workbook to each person and how to send the active workbook; but not how to send all workbooks in a folder to the appropriate person. I will have a workbook open that contains the email address for each person for comparison to the name of the file to be sent.
    Thanks in advance for any assistance.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Email all Workbooks in a folder (2003 sp2)

    You can use the code from the attached text file.

    Assumptions:
    - There are no other workbooks in the folder.
    - The active workbook has file names (including .xls) in column A and the corresponding e-mail addresses in column B.

  3. #3
    2 Star Lounger
    Join Date
    Jan 2004
    Location
    Melbourne, Fl USA
    Posts
    123
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Email all Workbooks in a folder (2003 sp2)

    It works great, thanks!

Posting Permissions

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