#1
|
|||
|
|||
share excel pdf format to email
I am using excel in office 365 on an Acer laptop running windows 10. I have been using the "File-Share-PDF" feature to send msgs to mutiple users some of whom do not have Office. Currently I am working a new project part of which I attach, "Bookings.xlsm". I want to make a data check before publication by email but wanted to check the "share as pdf" feature first. I recorded the sequence to a macro which produced the code: ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ "C:\Users\Owner\AppData\Local\Temp\Bookings.pd f", Quality:=xlQualityStandard _ , IncludeDocProperties:=False, IgnorePrintAreas:=False, OpenAfterPublish _ :=True Application.Dialogs(xlDialogSendMail).Show ', "C:\Users\Owner\AppData\Local\Temp\Bookings.pd f" When run the file "Bookings.pdf" is created and Outlook is opened showing a new email but the excel file "Bookings.xlsm" is attached instead of the pdf. If I do it "manually" using the ribbon the pdf is attached. |
Tags |
excel share pdf |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel workbook share in local network | allex011 | Excel | 0 | 10-04-2019 12:38 PM |
Share PDF files to an email address | RyanA | PowerPoint | 0 | 01-26-2016 09:24 PM |
OneNote 2010: Share Page via Email | mansmf | OneNote | 1 | 12-29-2014 05:21 PM |
Format email body-Using Excel VBA to send mail | Claytocb | Excel Programming | 1 | 01-31-2013 11:58 PM |
Share Excel Add-In In A Network Environment? | ibrahimaa | Excel | 5 | 04-30-2012 05:30 AM |