Delete File after sent mail in vb.net

Question

0.00/5 (No votes)

See more:

i want to delete a file which is attached to the mail after mail sent.
But it throws error of "The process cannot access file "c:/InVisitors.CSV" because it is being used by another process

i used the following code .......

path = "c:/InVisitors.CSV"
                    returnValue = VisDtlsOfEachVisitor
                    File.WriteAllText(path, returnValue)
                    Dim attach As Attachment = New Attachment("c:/InVisitors.CSV")
                    Mail.Attachments.Add(attach)
                    Message = "<HTML><BODY>" _
            & "Dear Sir,<br>" _
            & "<br>" _
            & "<br>" _
            & " Please find the attachment for the List of InVisitors.<br>" _
            & " And the List contains the Visitors Name and ID. " _
            & "<br>" _
            & "<br>" _
            & "Thanks & Regards,<br>" _
            & "iSpirit Technologies<br>" _
            & "<br>" _
            & "</BODY></HTML>"
                    Mail.Body = Message
                    Mail.IsBodyHtml = True
                    Mail.Priority = MailPriority.Normal
                    SmtpClient.EnableSsl = True
                    SmtpClient.Credentials = New Net.NetworkCredential(MailAdress, Password)
                    SmtpClient.Send(Mail)
                    Dim FileToDelete As String
                    FileToDelete = "c:/InVisitors.CSV"
                    If System.IO.File.Exists(FileToDelete) = True Then
                        System.IO.File.Delete(FileToDelete)
                    End If
                    MessageBox.Show(" Your message has been sent successfully ", "Done", MessageBoxButtons.OK, MessageBoxIcon.Information</br></br></br></br></br></br></br></br></br>

[edit]Code block added - OriginalGriff[/edit]

Posted 16-Apr-11 4:36am

Parshu2378

Updated 16-Apr-11 12:18pm

Dalek Dave

v3

Add a Solution

2 solutions

Solution 2

Adding to Albin Abel's answer:
If the Mail and Smtp Classes are used in a local code block (rather than on Class level) it may also help if you properly Dispose of them before you try to delete the file. You should do this with a Try, Finally or Using, End Using statement (in case the mail fails, you still want to Dispose of it). If you use them on Class level you should Dispose of them too, of course, just not at this particular point in your code.

parshu2378 wrote:
SmtpClient.Credentials = New Net.NetworkCredential(MailAdress, Password)
SmtpClient.Send(Mail)

Just want to say the, you should take the delivery notification, which will ensure the process flow.

Posted 17-Apr-11 11:24am

Sander Rossel

Updated 18-Apr-11 4:33am

v3

Comments

Sander Rossel 18-Apr-11 11:43am

Is there a reason for modifying my post for this or did you simply misclick?

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Albin Abel · Accepted Answer · 2011-04-16T05:21:00

Solution 1

Hi Handle the SmtpClient's SendCompleted event to delete the file.

I was just thinking if the mail failed to receive what's your plan. Lose the attachment?

Posted 16-Apr-11 5:21am

Albin Abel

Updated 16-Apr-11 9:31am

v2

Comments

Abhinav S 16-Apr-11 12:58pm

Good answer. May help the OP if implemented correctly.

Albin Abel 16-Apr-11 14:34pm

Thanks Abhinav. That is the only event available in the smtpClient class :)

Dalek Dave 16-Apr-11 18:19pm

Good Call