attach pdf

Hi, I'm trying to get the following code to only attach a pivot table on the page as the pdf. Private Sub CommandButton1_Click() Dim IsCreated As Boolean Dim i As Long Dim PdfFile As String, Title As String Dim OutlApp As Object ' Define PDF filename PdfFile =...

Hello experts, I have a macro that creates an email, attaches two excel files and all the pdf files in a specified folder. The macro does not return any errors, but there are certain pdf files that don't get attached. Those files have in the name "‐". This is not a normal hyphen. When I use...

Dear All, please help. It worked before but suddenly it started to send the same email few times to the same recipient if there is indicated another email in c.c. So it works like this - I have range in excel that it makes as pdf and send an email and when it goes to next one etc. Please help...

I am developing a small VBA program and I am looking for an easy way for my users to "attach" a source file to a table record. Ideally, I would like the user to be able to click a command button which brings up some kind of save as dialog box. The user could then drag and drop a file from...

Hi all, The macro is as follows: a sheet is made and then saved as xlsx and pdf. Then outlook opens and set (only) the pdf as attachment. However i have more then 1 attachment. So the first 1 is made of an excel sheet and autopasted in the new mail. Te rest are manuals and are already in PDF. I...

Hello, I am trying to make a process more efficient where by each name in my spreadsheet has a pdf attachment that needs to be sent out to them. Instead of manually attaching each file in the email the VBA opens I would like the VBA to refer to the cell with the hyperlink to the PDF and then...

Good Morning All, I am attempting to make a macro that will create a pdf, then attach it to Outlook email. I have succeeded in getting it to, create, address correctly but not attach the pdf. Below is my script: Dim SheetName As String SheetName = ActiveSheet.Name...