Software

Ask something
Discussion Locked

Auto attach/send email from Exchange

0 helpful
3 replies

by daveyuen

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I wish to write a script or VBA to use Exchange/Outlook to auto attach a file from a folder and send it out automatically on a daily basic, is there any suggestion or example link? thanks!

Dave

3 replies

by sgt_shultz

the help available from within the outlook vba editor was the most help to me. has examples.

by pt31

You can use the sendmail function to send an excel spreadsheet for example.

activeworkbook.sendmail recipients:=array("name1", "name2", .....),suject:="subject description"

Hope this helps you.

This discussion is closed to new replies.