Thread: [Solved] Email from Command Button
View Single Post
 
Old 05-04-2016, 08:19 AM
derajlance derajlance is offline Windows 10 Office 2013
Novice
 
Join Date: May 2016
Posts: 18
derajlance is on a distinguished road
Default

Thank you! Slightly disappointed to learn that the text from the fields can't just be copied and pasted, but that's life.

The first option you presented won't work because I need the fields to ensure consistency in the formatting. Without those fields, they don't seem to grasp how to format the email I need.

Re: the second option to send as an attachment, I see that it requires the document to be saved.

Code:
ActiveDocument.Save
    sDocname = ActiveDocument.FullName
    If Len(ActiveDocument.Path) = 0 Then
        MsgBox "Document is not saved!"
        GoTo lbl_Exit
Is there a way to remove that and make it automatically save in a temporary folder upon clicking submit and it be deleted after sending? I hope that makes sense.

Last edited by macropod; 05-04-2016 at 08:36 AM. Reason: Deleted unnecessay quote of entire post replied to.
Reply With Quote