Hello,

I have a tool that allows the user to click send email and it will attach a worksheet to an email. However when the user opens up the email, the attachement does not have a file association (i.e. xls), how would I define this?

Any help would be greatly appreciated

Kind regards,

Alan

Private Sub cmd_enter_Click()

Dim i As Integer
Dim strSubject As String
Dim strMessage As String
Dim strRecipients As String
Dim details As Worksheet
Dim wbSend As Workbook

Dim objSession As MAPI.Session
Dim objNewMessage As MAPI.message
Dim objRecipient As MAPI.Recipient
Dim objAttachment As MAPI.Attachment

    ' Check the user is ok to send
    If MsgBox(Prompt:="Please click yes to sent", Buttons:=vbYesNo) = vbNo Then Exit Sub

    ' Set the subject of the e-mail
    strSubject = "New User Update"

    ' Set the text of the e-mail
    strMessage = "Please find attached update for Tool"

    ' Set the recipient names
    strRecipients = "email address"

    ' Save a tempory copy of the sheet with the correct filename
    Set details = ThisWorkbook.Sheets("Details")
    Set wbSend = Workbooks.add

    details.Copy Before:=wbSend.Sheets(1)

    FName = "C:\Documents and Settings\noblea\Desktop"
    wbSend.SaveAs Filename:=FName

    ' Close the Temp file
    wbSend.Close SaveChanges:=False

    ' Start CDO session
    Set objSession = New MAPI.Session
    objSession.Logon "", "", False, False

    ' Create a new message
    Set objNewMessage = objSession.Outbox.Messages.add
    With objNewMessage

        .Subject = strSubject
        .Text = strMessage

        ' Add recipients one by one and resolve against the directory
        i = InStr(1, strRecipients, ";", vbBinaryCompare)
        Do Until i = 0
            Set objRecipient = .Recipients.add
            objRecipient.Name = Left(strRecipients, i - 1)
            objRecipient.Resolve
            strRecipients = Mid(strRecipients, i + 2)
            i = InStr(1, strRecipients, ";", vbBinaryCompare)
        Loop
        Set objRecipient = objNewMessage.Recipients.add
        objRecipient.Name = strRecipients
        objRecipient.Resolve

    End With

    ' Attach the tempory file to the e-mail
    Set objAttachment = objNewMessage.Attachments.add

    objAttachment.Position = 0

Set objAttachment = objNewMessage.Attachments.add

    ' Delete the tempory copy


    ' Send the e-mail
    objNewMessage.Update
    objNewMessage.Send

    'Release memory
    Set objNewMessage = Nothing
    Set objSession = Nothing
    Set objAttachments = Nothing
    Set objRecipient = Nothing

    ' Reassuring message
    MsgBox "File Sent Successfuly"

End Sub

Have you tried putting a proper xl filename in the FName variable?

Maccas

It still send 2 attachements, which have no name and no file extension. HELP!

Thanks

Alan

I seem to remember we've been through this before but you don't appear to be attaching the file properly. You should either try:
or
instead of