473,320 Members | 2,098 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

How Do Youn Email All Contents Of A Folder In Access

I need to create a routine that will email all contents of a folder.
But The number of files and extensions will be different. Some will
have .doc and .xls. Is there a way to email the contents without having
to know the names of each file--or is there a may to interate through
the contents of the folder to get the names? Any help would be
appreciated. Thanks.

Bill Mahoney
The Alcott Group
bi***@alcottgroup.com

Sep 7 '06 #1
3 1633

Madingo wrote:
I need to create a routine that will email all contents of a folder.
But The number of files and extensions will be different. Some will
have .doc and .xls. Is there a way to email the contents without having
to know the names of each file--or is there a may to interate through
the contents of the folder to get the names? Any help would be
appreciated. Thanks.

Bill Mahoney
The Alcott Group
bi***@alcottgroup.com
You could probably use CDO to handle the mailing routine stuff (search
the NG - I remember Lyle's nice example, so have a dig for that). Now
for the "entire contents of a directory" part.
1. if the path changes all the time, you could use the BrowseFolder API
at www.mvps.org/access I think it's the first or second one in the
API section. It will return the full path to a directory.
2. then you can use DIR to loop through the contents and add to the
Attachments collection. There are examples of that here somewhere too.
(I'm sure, since I asked the question).
Once you've collected and attached all the contents of the directory,
you would just add a line of code to send the message and then go on to
the next record. If different people get the contents of different
folders, then it might get a little trickier, but not much.

Sep 7 '06 #2
On 7 Sep 2006 08:16:32 -0700, "Madingo" <bi***@alcottgroup.comwrote:
>I need to create a routine that will email all contents of a folder.
But The number of files and extensions will be different. Some will
have .doc and .xls. Is there a way to email the contents without having
to know the names of each file--or is there a may to interate through
the contents of the folder to get the names? Any help would be
appreciated. Thanks.

Bill Mahoney
The Alcott Group
bi***@alcottgroup.com
The easiest way to emai a folder is to zip it.

Sep 7 '06 #3
On Thu, 07 Sep 2006 18:00:44 GMT, person <sn**@snappers.comwrote:
>On 7 Sep 2006 08:16:32 -0700, "Madingo" <bi***@alcottgroup.comwrote:
>>I need to create a routine that will email all contents of a folder.
But The number of files and extensions will be different. Some will
have .doc and .xls. Is there a way to email the contents without having
to know the names of each file--or is there a may to interate through
the contents of the folder to get the names? Any help would be
appreciated. Thanks.

Bill Mahoney
The Alcott Group
bi***@alcottgroup.com

The easiest way to emai a folder is to zip it.
P.S. Googling will find ways of doing this, see for example

http://groups.google.co.uk/group/com...1b2979effba7a5
Sep 7 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Dave Smithz | last post by:
Hi There, I have a PHP script that sends an email with attachment and works great when provided the path to the file to send. However this file needs to be on the same server as the script. ...
3
by: scoop_77 | last post by:
I'm looking for some software that would allow me to point to a folder in Windows Explorer, and have it output an html file with hyperlinks to all of the files within that folder and all of the...
2
by: Susan Bricker | last post by:
I know that it is possible to generate an email letter and send it from VBA behind a form. I've done that. However, is it possible to create a DRAFT email letter and leave it in the Drafts folder...
1
by: jon.ingram | last post by:
I need some vb code that I could perhaps run from access that will look in a particular folder I could specify in the code, and convert all the files (just excel are saved there) to .csv. Is...
1
by: Mike P | last post by:
I am trying to move the contents of the inbox folder into a folder for archiving. I have found a few examples on MSDN (eg http://msdn2.microsoft.com/en-us/library/bb206765.aspx), but I don't...
1
by: rmarek | last post by:
I need to create an Outlook email from within Access that adds all the contents of a specific file folder as attachments. I have been able to get the email created and drop it into the Outlook...
1
by: dearprasan | last post by:
I have a custom browser application built in C#. I want to access the Internet Explorer's Cache to display contents on this custom browser application. For example: If the user types "www.msn.com"...
1
by: E11esar | last post by:
Hi there. I have a folder within my asp.net (c#) project in VS2008 called Files. Within this folder is a text file called files.txt. Is there a way to access this folder from the C# code...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.