attach pdf

  1. S

    If Dir(FullName) <> vbNull String Then Giving Runtime Error 52

    Howdy! This VBA code has been running strong for a year, then all of a sudden I got a call today that it's started giving an error, and I'm really not sure what to do to fix it, as I essentially backwards engineered some other code to get this to work and I have no actual clue what I'm doing...
  2. A

    VBA attach pdf to email (pivot table)

    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 =...
  3. R

    Attach all files in folder not working fully

    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...
  4. M

    When I send email from excel with VBA it sends two times

    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...
  5. R

    Saving a non-Excel separate file and recording the URL

    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...
  6. M

    Macro send multiple pdf per mail.

    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...
  7. S

    Add PDF link from cell as attachment

    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...
  8. C

    Macro to create and attach pdf

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top