Outlook signature - Edit before sending?

[fredalina]

Edited to say I found the answer (change .Send to .Display). i had Googled, but not the right combination of terms apparently.

Thanks!


I have the following code in my database to send an email with attachments. Unfortunately, when it sends the email from MS Outlook, the user's Outlook signature is not included in the email.

Is there a way to alter the code to send attachments (as part of a Select Case that counts the number of attachments first), and includes the user's signature, or that allows the code to stop for editing of the email before sending (to allow the user to manually add their signature)?

Here's the code:

            Set objOutlook = CreateObject("Outlook.Application")
            Set Message = objOutlook.CreateItem(olMailItem)
            With Message
                .To = recipient
                .Subject = subject
                .body = body
                .Attachments.Add ([URL="file://\\server\folder\folder\filename.xls"]\\server\folder\folder\filename.xls[/URL])
                .Attachments.Add (Me.AttPath1.Value)
                .Send
            End With

Thanks!