Send Email with attachments from within Access

  • Thread starter Thread starter RC
  • Start date Start date
R

RC

In My MS-Access Application I create a spreadsheet with
"DoCmd.OutputTo ....."
Then some things are changed in the spreadsheet.
After that the spreadsheet has to be mailed.
How Can I send an Email with the spreadsheet attached?
I know I can Use:
Call Shell("C:\Program Files\Outlook Express\msimn.exe", 1)
To start Outlook Express.

Can I use commandline parameters in the shell-string?
Where can I find these?

Thanks RC
 
In My MS-Access Application I create a spreadsheet with
"DoCmd.OutputTo ....."
Then some things are changed in the spreadsheet.
After that the spreadsheet has to be mailed.
How Can I send an Email with the spreadsheet attached?
I know I can Use:
Call Shell("C:\Program Files\Outlook Express\msimn.exe", 1)
To start Outlook Express.

Can I use commandline parameters in the shell-string?
Where can I find these?

Thanks RC
Click to expand...
If you want to do this entirely from within Access - and avoid the
security notification issue - then consider using the open source
command line emailer Blat. I just finished an application with it and
it works superbly.

Then email is sent in code including any attachments that you want.
Info here ...

http://blat.freeshell.org/

You can shell it using command line parameters.

- Jim
 
Back
Top