how to copy query results to outlook public folder

[mak101]

I need to send consolidated data in spreadsheet from access database to group of people everyday. What I am thinking is, instead of sending an attachment everyday, copy spreadsheet to public folder and send them an email announcing new data on the public folder. And I don't need old copy of spreadsheet so just want to overwrite the old one.

Is this doable? Can someone please give me sample code to accomplish it.

Thanks.

[ajetrumpet]

there are plenty of email examples on the web of how to email using vba, but copying a file is about one line of code, regardless of the way you do it. you can copy it using DOS, or using a vba function.

to copy using DOS, you can use the 'xcopy' command:

Shell Environ("COMSPEC") & " /C xcopy" & """" & drive:\oldfilepath drive:\newfilepath & """" & ", 1"

[mak101]

This is not a windows folder, I am talking about copying file to outlook public folder on exchange server.

[mak101]

anyone please?