word automation vb.net

[Steve]

I've been building an application that will merge fields in a text file with
a word template, save the resulting word file out to the user's hard drive,
and then email the file as an attachment.

The problem I'm having is that I can't delete the word file I saved at the
end of the process due to the file being locked by the email process. It
appears to take longer than the code takes to complete due to virus checking
software that intercepts the mail before releasing it (at least that's what
I've narrowed it down to).

I don't want to leave the file around after the code has completed. And I
don't think I want to hold up the completion of the code process until the
email gets sent in case the email process takes longer on some machines than
others.

I'm not sure if there is a better way to handle the attachment in the code
so I don't have to save a file to the user's desktop. Or if I can use a
deattach process that I can trigger from code to delete the file later. Or
something else.

I've attached a snippet of the code below:

Thanks
Steve

------------

WordDoc.SaveAs( sSaveFileName)
Do While Not WordDoc.Saved
Application.DoE vents()
Loop
WordDoc.Close(W ord.WdSaveOptio ns.wdDoNotSaveC hanges)

' Email the Saved Merge Document.

Dim Fromaddress As New MailAddress("fr omaddress")
Dim Toaddress As New MailAddress("to address")
Dim myMail As New MailMessage(Fro maddress, ToAddress)
myMail.Subject = "test"
Dim AttachmentFile As Attachment = New Attachment(sSav eFileName)
myMail.Attachme nts.Add(Attachm entFile)
myMail.Priority = MailPriority.Hi gh
Dim client As New SmtpClient
client.Host = "hostaddres s"
client.Send(myM ail)

' Release the references.

WordMailMerge = Nothing
WordDoc = Nothing
WordApp = Nothing

' Delete the temporary files.

System.IO.File. Delete(sSaveFil eName)

[RobinS]

Thanks -- that makes me feel better. I just couldn't think
of another way. I was afraid I was going to get a lot of
negative feedback for the method I chose!

Robin S.
-------------------------------
"Robinson" <bb*@bbb.comwro te in message
news:lq******** *************** *******@giganew s.com...

>

>So this is what I did: I created the files in my
application directory and named them with a specific
pattern, like Temp_yymmddhhmm ss.csv.

Then every time they started up the application,
it would delete any files it found in the application
folder with the pattern Temp_*.csv.

I do this with temporary files. Typically I generate a hundred or so
during an average running session, which are all in a user data directory.
This directory is cleaned during program startup.

[Steve]

I figured out a solution to my problem. After client.send, I issue a
mymail.dispose. It releases the hold on the file which allows me to delete
it.

Steve

-----

Dim Fromaddress As New MailAddress("fr omaddress")
Dim Toaddress As New MailAddress("to address")
Dim myMail As New MailMessage(Fro maddress, ToAddress)
myMail.Subject = "test"
Dim AttachmentFile As Attachment = New Attachment(sSav eFileName)
myMail.Attachme nts.Add(Attachm entFile)
myMail.Priority = MailPriority.Hi gh
Dim client As New SmtpClient
client.Host = "hostaddres s"
client.Send(myM ail
myMail.Dispose( )


"RobinS" <Ro****@NoSpam. yah.nonewrote in message
news:Nd******** *************** *******@comcast .com...

Thanks -- that makes me feel better. I just couldn't think
of another way. I was afraid I was going to get a lot of
negative feedback for the method I chose!

Robin S.
-------------------------------
"Robinson" <bb*@bbb.comwro te in message
news:lq******** *************** *******@giganew s.com...

So this is what I did: I created the files in my
application directory and named them with a specific
pattern, like Temp_yymmddhhmm ss.csv.

Then every time they started up the application,
it would delete any files it found in the application
folder with the pattern Temp_*.csv.

I do this with temporary files. Typically I generate a hundred or so
during an average running session, which are all in a user data

directory.

This directory is cleaned during program startup.

[RobinS]

Woohoo! Thanks for letting us know.
Congrats.
Robin S.
--------------------------------------
"Steve" <s.*****@comcas t.netwrote in message
news:ua******** ******@TK2MSFTN GP03.phx.gbl...

>I figured out a solution to my problem. After client.send, I issue a
mymail.dispose. It releases the hold on the file which allows me to
delete
it.

Steve

-----

Dim Fromaddress As New MailAddress("fr omaddress")
Dim Toaddress As New MailAddress("to address")
Dim myMail As New MailMessage(Fro maddress, ToAddress)
myMail.Subject = "test"
Dim AttachmentFile As Attachment = New Attachment(sSav eFileName)
myMail.Attachme nts.Add(Attachm entFile)
myMail.Priority = MailPriority.Hi gh
Dim client As New SmtpClient
client.Host = "hostaddres s"
client.Send(myM ail
myMail.Dispose( )


"RobinS" <Ro****@NoSpam. yah.nonewrote in message
news:Nd******** *************** *******@comcast .com...

>Thanks -- that makes me feel better. I just couldn't think
of another way. I was afraid I was going to get a lot of
negative feedback for the method I chose!

Robin S.
-------------------------------
"Robinson" <bb*@bbb.comwro te in message
news:lq******* *************** ********@gigane ws.com...

>
So this is what I did: I created the files in my
application directory and named them with a specific
pattern, like Temp_yymmddhhmm ss.csv.

Then every time they started up the application,
it would delete any files it found in the application
folder with the pattern Temp_*.csv.

I do this with temporary files. Typically I generate a hundred or so
during an average running session, which are all in a user data

directory.

This directory is cleaned during program startup.