Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do you email a csv file using a macro in Access

Status
Not open for further replies.

kryton

Technical User
Feb 14, 2001
9
0
0
GB
Hope someone can help me.

I'm trying to run a macro in Access that will when called email a .csv file. The only problem i have is that the location of the file ("C:\WINDOWS\system\152565.csv"), is stored in a table, table name "crusaderFD",Field name "Location".

What I need to know is how do you tell access to look at a table and then the contents of a field to get the location of the file that needs to be attached to an email.

Please some help.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top