email attachments

[Mark]

I need a little help with sending email with attachments. I use Novel and I
am trying to send email with a text file attachment. I’m not sure if this can
be done with the SendObject method as I’m not sending a report or table but a
text file created from a table a DoCmd.TransferText command with a file spec.
Does anyone know how to do this? Access 20002, XP
Thanks,
Mark

 

[Douglas J. Steele]

I don't believe it's possible using SendObject.

Check whether Tony Toews has anything about your e-mail client in his Access
EMail FAQ at http://www.granite.ab.ca/access/email.htm

 

[Mark]

Thanks for the reply. I assume I will have to call Novell with some tricky
code. I’ve been looking on Novell sites but no luck.
Thanks again,
Mark

 

[Douglas J. Steele]

I'm not sure the fact that you're on a Novell network really matters. Or
does Novell have its own e-mail client? (We used Novell eons ago, but used
Outlook for e-mail)

 

[Mark]

That’s really the question, is Novell significantly different than Outlook
requiring its own syntax. Even with Outlook I don’t have a means to open
Outlook with a text attachment, meaning something other than a MS Access
report, table, ect (SendObject).
I’m trying to deliver data state wide and allow users to download text files
into their respective tables. I want to automate this process as much as
possible. I can create the text files and walk each user through the email
and attachment but that’s problematic. It works but I’m trying to find a
better way.
Thanks,
Mark

 

[susan roads]

GOT FUN ??

 

[susan roads]

DOGS !!

GOT FUN ??

 

[Douglas J. Steele]

You need to use automation of Outlook in order to attach text files.

See Tony's EMail FAQ.

 

[Ian B]

Mark

Depending on how heavy you want to get with the programming, here is a link
to a VB6 routine which should translate fairly easily to Access VBA.
There is a dll which you interface to, but there are good and complete
examples of VB6 code
May need to redo the form.
www.toadworld.net/PublicShared/Email%20Tools/vbSendMail/vbSendMail.doc

It bypasses all mail clients and talks directly to SMTP mail.

HTH

Ian B