OutputTo Then SendObject

[DocB1973]

I have an OutputTo line in my macro that creates a file that is named based
on standard verbiage and the quote number. Is there a way to use SendObject
to attach the file created in the OutputTo line to an email?

Thanks,
DocB1973

 

[Steve Schapel]

Doc,

Not 100% autoimatic, I'm afraid. You could do your SendObject, with no
object specified, and set the 'Edit Message' argument to Yes. This will get
the email opening in your email client, with message and recipient details
ready to go, but then you will need to manually attach the file created by
the OutputTo action before sending.

 

[DocB1973]

Steve,

Do you know of any code that may do this? I appreciate your reply.

 

[Steve Schapel]

Doc,

You will be able to do this with VBA, one way or another. See if there is
anything useful to you at http://www.granite.ab.ca/access/email.htm