Email - Help

[PHolmes]

Does anyone know whether using VB is it possible to pull in a text file into the body of an email??

 

[BukHix]

Are you trying to get a text file external to the database? - SendObject (attachments)

Or are you trying to put the text from a field into the body of the email? - email field (text in body)

I guess the third option could be that you want to get text from a file and put it in the body of the message, let me know if that is the case. Post back if you have more questions.



[This message has been edited by BukHix (edited 12-14-2001).]

 

[PHolmes]

Sorry, I am looking at the third option. I have a .txt file that i would like to import in to the body of an email message. Any suggestions would be apprecaited. Many thanks for your time.

 

[BukHix]

Ok this should do it for you:

Dim strText As String

Open "c:\TestFile.txt" For Input As #1
Do While Not EOF(1)
Line Input #1, strText
Loop
Close #1

DoCmd.SendObject , , , "bukhix@mydomain.com", , , "OptionalSubject", _
strText, True

Just change the file path location and the email address and you should be all set.

[This message has been edited by BukHix (edited 12-14-2001).]

 

[ctuor]

This would only leave you with the last line of the text file
What about this
Dim strText As String

Open "c:\TestFile.txt" For Input As #1
Do While Not EOF(1)
Line Input #1, strText
if FullText<>"" then FullText=FullText & vbcrlf
FullText=FullText & strText
Loop
Close #1

DoCmd.SendObject , , , "bukhix@mydomain.com", , , "OptionalSubject", _
FullText, True

CT

 

[PHolmes]

Thank you both for your help. Much appreciated.

 

[BukHix]

Yes, thanks ctuor. I put that together without testing more then one sentance so I didn't realize it would only pull the last line.

Thanks again for the heads up.

 

[Haynesey]

Hi, I have used the same code for one of my databases. The email message opens fine but when i try and send it or close it, Access performs an illegal operation. Any ideas please?

 

[BukHix]

Haynesey's question has been continued here:

Topic: Automatic Email