Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Email files on C Drive
Hi All,
Have found similar postings, but not enough to go on in regards to the following. I currently have some VBA that does the following: - Creates individual file (with all the relevant records) for each unique name contained within Column G - Saves the file (with the name of the unique entry) .xls What I'd like to do is extend this to be able to automatically send an e-mail with pre-set text to advise the users (user is the unique entry in column G) what they next need to do (so I'd need to include some e- mail text as well). The unique entry isn't the SMTP address, it's the internal user's name as it appears in our address book (e.g. Smith, Bob) I'd like it instead of automatically sending, at least at first, to prompt the person who's running it as to whether they want to send at first. So, in summary: 1) Run through all xls files on C Drive and attach the file to an e- mail with some pre-defined subject/content text 2) Populate the to box on the e-mail with the file name (less the .xls part) Appreciate your help on this. Many Thanks, Al. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 tmp files filling up drive with XLSM files | Excel Worksheet Functions | |||
Drive Erased, got Files back but only excel files scrambled, help. | Excel Discussion (Misc queries) | |||
Loop through all files on a floppy drive | Excel Programming | |||
Drive - Folders - Files | Excel Discussion (Misc queries) | |||
Can I move files From Drive to drive using VBA | Excel Programming |