Email files automatically

[Guest]

Hi - and thanks for reading this.
I have a directory of .TXT files that I need to email to different email
addresses each. I know I could do it manually but I'm looking for a smarter
solution!
The way I was planning to do this was by creating a table of the file names.
I can then link this table to an email address table (the name of the file,
eg ABC001.TXT will be sent to an email relating to an account called
ABC123). The only way I can think of automating the email-sending is to
create hundreds of macros - one for each account - but that is not practical
as new accounts are created all the time.
I'm sorry this is a bit vague but it's difficult to explain!
Any help/suggestions would be greatly appreciated!
Andy.

 

[pietlinden]

Hi - and thanks for reading this.
I have a directory of .TXT files that I need to email to different email
addresses each. I know I could do it manually but I'm looking for a smarter
solution!
The way I was planning to do this was by creating a table of the file names.
I can then link this table to an email address table (the name of the file,
eg ABC001.TXT will be sent to an email relating to an account called
ABC123). The only way I can think of automating the email-sending is to
create hundreds of macros - one for each account - but that is not practical
as new accounts are created all the time.
I'm sorry this is a bit vague but it's difficult to explain!
Any help/suggestions would be greatly appreciated!
Andy.

open a recordset based on the table/query to select the files/
recipients you want to e-mail, and then automate outlook to do it.

 

[FMS Development Team]

Hi - and thanks for reading this.
I have a directory of .TXT files that I need toemailto differentemail
addresses each. I know I could do it manually but I'm looking for a smarter
solution!
The way I was planning to do this was by creating a table of the file names.
I can then link this table to anemailaddress table (the name of the file,
eg ABC001.TXT will be sent to anemailrelating to an account called
ABC123). The only way I can think of automating theemail-sending is to
create hundreds of macros - one for each account - but that is not practical
as new accounts are created all the time.
I'm sorry this is a bit vague but it's difficult to explain!
Any help/suggestions would be greatly appreciated!
Andy.

Hi Andy,

Have you checked out our Total Access Emailer program? It can handle
your situation very easily.

If you have a table with a list of email addresses, and a field with
the file names you want to attach, it'll attach those files to the
email you send to them. In Access 2007, if the files are stored in an
Attachment field, it would send those.

For more info vsit http://www.fmsinc.com/MicrosoftAccess/Email.asp
A free 30 day trial/demo version is available.

Hope this helps. Good luck!

Luke Chung
FMS, Inc.
http://www.fmsinc.com

P.S. Visit our Micosoft Access Help Center for more resources:
http://www.fmsinc.com/MicrosoftAccess/help.html