|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
VBA to create a button to attach the active word doc to an email as a PDF without using Outlook
I sincerely apologize if this exact question has been asked before - I've been searching for awhile and haven't had much luck.
Very new to VBA - trying to use a macro to create a "submit" button that will convert the active document to a PDF and attach it to an email in IBM Notes. Most of the resources I've found provide code to perform this operation using Microsoft Outlook as the email client, but I haven't been able to find out much otherwise. I've had success adding the document to an email in IBM Notes using this code: Private Sub CommandButton1_Click() Options.SendMailAttach = True ActiveDocument.SendMail End Sub However, it would be ideal if I could have the document attached as PDF. I was also able to find coding to save the active document as a PDF: Sub CommandButton1_Click() ActiveDocument.ExportAsFixedFormat OutputFileName:= _ "C:\Users\example\DocName", _ ExportFormat:=wdExportFormatPDF, OpenAfterExport:=False, OptimizeFor:= _ wdExportOptimizeForPrint, Range:=wdExportAllDocument, From:=1, To:=1, _ Item:=wdExportDocumentWithMarkup, IncludeDocProps:=False, KeepIRM:=True, _ CreateBookmarks:=wdExportCreateNoBookmarks, DocStructureTags:=True, _ BitmapMissingFonts:=True, UseISO19005_1:=False End Sub I'm able to successfully create the PDF document using that code, saving it to the location listed "C:\Users\example\DocName" - I don't really need to keep the document saved as a PDF if I can get it to attach to an email in IBM Notes. Any help is greatly appreciated! Thanks!! |
#2
|
||||
|
||||
http://www.cpearson.com/Excel/EMail.aspx might point a way.
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
Tags |
macro, vba, word 2010 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I attach a ribbon button to a particular template in Word 2010? | HelenT | Word VBA | 1 | 10-07-2015 03:32 AM |
File Not Found error when trying to attach Word document to email | Kimber | Word | 0 | 03-06-2015 06:47 PM |
Having Touble Finding Word File When Trying to Attach to Email | freetibet213 | Word | 3 | 12-28-2011 05:26 AM |
Drag Button which refers to the active Word document to Explorer | DRob | Word | 0 | 10-03-2010 06:40 AM |
Help on option button active X | aligahk06 | Excel | 0 | 11-03-2009 11:39 PM |