Solved: VBA to auto email report

[jo15765]

I have a excel form that I push a button on the form, and it opens a new workbook, calls it "New", runs a DAO import of data, and saves "New" with the imported data. I then manually right click the file, say send to, email recipient...etc etc. Is there a way for me to automatically place the "New" file in an attachment in outlook 2007?

[Simon Lloyd]

check this out http://www.rondebruin.nl/sendmail.htm

[jo15765]

check this out http://www.rondebruin.nl/sendmail.htm

Cool, thank you for the link! I will give it a whirl, and see if I can get it functioning perfectly :bow:

[jo15765]

That code is great!! Now I have one other VB question related to the

.Body


statement in the code. How can I add a carraige return between the lines I want added in the statement?

[Simon Lloyd]

Use& vblf