Thread: Daily email, with attachment.

You guys at excelforum.com have always helped me in Excel, I don't see why Outlook should be any different, so thank you in advance for any help you can offer.

Here's what I'm trying to do:

I have an inventory data base software that will automatically generate a report, in .txt format, every morning at 9:00 and save it to a network share.

I would like Outlook to generate an email everyday, say 9:30, then attach the overwritten .txt file and send the message to predetermined recipients, of which - addresses will not change.

Similarly, I intend to have the .txt file overwrite the previous file, so the name and location of the file would not need to change for the attachment each day.

Any thoughts are certainly appreciated.

- Thanks

I am not going to give you code but make some suggestions. Once you have some code then come back if you cannot get it working.

Basically Outlook does not have a timer so doing something at 9.30am in Outlook is going to be difficult.

I would suggest you use your Excel to generate and send the email. The only difficulty with this is that someone will have to be present to click a stupid security button if you are in Office 2003 still.

So putting this together you need a timer to go off 30 min after your 9.00 am report in Excel.

Then you just write some simple VBA email code - I am sure there are lots of examples in this forum and others. This code will also add an attachment.

http://www.rondebruin.nl/sendmail.htm

http://www.exceltip.com/st/Control_O...Excel/464.html

I hope this helps.

some more reading for you:

http://www.howto-outlook.com/howto/recurringemail.htm

http://www.repeatmail.com/

just seen the date on this post. I may have been a bit late with the reply as I gathered you have an answer by now (hopefully, after 2 years)

Wow, I could've swore I had email notifications set up for this! I never got them. Thanks guys for your answers. Unfortunately, I never did get this one figured out. I just came up with a different, albeit, not as cool, solution for the problem. Thanks for taking the time to respond and sorry I didn't see this earlier.

- YKA