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?
check this out http://www.rondebruin.nl/sendmail.htm
Regards,
Simon
Please read this before cross posting!
In the unlikely event you didn't get your answer here try Microsoft Office Discussion @ The Code Cage
If I have seen further it is by standing on the shoulders of giants.
Isaac Newton, Letter to Robert Hooke, February 5, 1675 English mathematician & physicist (1642 - 1727)
Cool, thank you for the link! I will give it a whirl, and see if I can get it functioning perfectlyOriginally Posted by Simon Lloyd
That code is great!! Now I have one other VB question related to the
[vba]
.Body
[/vba]
statement in the code. How can I add a carraige return between the lines I want added in the statement?
Use[VBA]& vblf[/VBA]
Regards,
Simon
Please read this before cross posting!
In the unlikely event you didn't get your answer here try Microsoft Office Discussion @ The Code Cage
If I have seen further it is by standing on the shoulders of giants.
Isaac Newton, Letter to Robert Hooke, February 5, 1675 English mathematician & physicist (1642 - 1727)
Posting Permissions
Reply With Quote
