Hi again
Well the code you supplied did take a" snap" shot of the form to a scratch work book ... Locked it up not sure where to go form there to get it into an email.
if it were to work the steps would have to be similar to:
1. User form search
2.command button 3 email form
code to get scratch image to worksheet. attach as PDF --> email
scratch image would need to be deleted
I have been searching and found code below ... is this appropriate to send the user form as a a small PDF .
Your advice appreciated
Sub AttachActiveSheetPDF() Dim IsCreated As Boolean Dim i As Long Dim PdfFile As String, Title As String Dim OutlApp As Object ' Not sure for what the Title is Title = Range("A1") ' Define PDF filename PdfFile = Sheet1.GPUEjournalling i = InStrRev(PdfFile, ".") If i > 1 Then PdfFile = Left(PdfFile, i - 1) PdfFile = PdfFile & "_" & Sheet1.GPUejournalling & ".pdf" ' Export activesheet as PDF With ActiveSheet .ExportAsFixedFormat Type:=xlTypePDF, Filename:=PdfFile, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=False End With ' Use already open Outlook if possible On Error Resume Next Set OutlApp = GetObject(, "Outlook.Application") If Err Then Set OutlApp = CreateObject("Outlook.Application") IsCreated = True End If OutlApp.Visible = True On Error GoTo 0 ' Prepare e-mail with PDF attachment With OutlApp.CreateItem(0) ' Prepare e-mail .Subject = Title .To = "Textbox13" ' <-- Put email of the recipient here .CC = "..." ' <-- Put email of 'copy to' recipient here .Body = "Hi," & vbLf & vbLf _ & "The report is attached in PDF format." & vbLf & vbLf _ & "Regards," & vbLf _ & Application.UserName & vbLf & vbLf .Attachments.Add PdfFile ' Try to send On Error Resume Next .Send Application.Visible = True If Err Then If Err Then MsgBox "E-mail was not sent", vbExclamation Else MsgBox "E-mail successfully sent", vbInformation End If On Error GoTo 0 End With ' Delete PDF file Kill PdfFile ' Quit Outlook if it was created by this code If IsCreated Then OutlApp.Quit ' Release the memory of object variable Set OutlApp = Nothing End Sub MsgBox "E-mail was not sent", vbExclamation Else MsgBox "E-mail successfully sent", vbInformation End If On Error GoTo 0 End With ' Delete PDF file Kill PdfFile ' Quit Outlook if it was created by this code If IsCreated Then OutlApp.Quit ' Release the memory of object variable Set OutlApp = Nothing End Sub





Reply With Quote