email as pdf

Hi all, I have the below code which saves the current worksheet as a PDF file and then sends the worksheet out, but I would rather it send the PDF, can someone help? Thanks, Karl Dim OutApp As Object Dim OutMail As Object Dim saveLocation As String Set wb1 = ThisWorkbook saveLocation =...

Hi all, NEW to VBA and attempting to create a module to save and send a PDF to a LIST of recipients. This list is on Sheet 2 and does not vary. (Not dependent on information in reports) Range is A2-A25 Sheet 2. I can only seem to find Modules with one recipient - or variables. Any support...

The codes open a Email find but can`t seem to grab any files? Private Sub Email_Files_Click() Dim objol As Object Dim objmail As Object Dim objFolder As Object Dim fso As Object Dim fsFolder As Object Dim fsFile As Object Dim strFolder As String...

Good morning All. First time poster, but have used the forum and associated code more time then I care to admit! Unfortunately, I have not been able to find/modify code to achieve what I want to do. I have workbook that has a number of sheets (for this example, they are named Item1 to Item8). I...

Hi, I have a project which I am currently undertaking. I am currently trying to create a code that will take the info in A:A TO G:G, and email them to the multiple emails in H2. The deadlines in this sheet will be extracted from another sheet from the same workbook I also would want to create...

Hi, I have a spreadsheet with names in Column A and email address in column B. There are PDF attachments for all names mentioned in Column A, in a single folder. I found a macro that can send an email to all recipients mentioned in column B, and attach the corresponding attachments from that...

I've created a macro that will copy a set range in excel and paste into the body of an email as an image. I'm experiencing issues with the picture resolution when reading on a smart phone device. To improve the resolution I've set the macro to zoom in, copy and paste however this has had little...

Hi I am after a VBA code to select certain sheets of my excel workbook .xlsx, convert them to .pdf and email it via outlook. Thanking in advance.

I have a very small VBA app that begins with a Workbook with four Worksheets. It opens another Workbook, reads data from the only Worksheet in this Workbook (which is generated by an Access Database Macro), populates a "form" on a Worksheet named "Report" in the "master" Workbook, creates a PDF...

Hello, I am seeking help with code to pdf a certain tab on my workbook and then send an email with that pdf attached to whatever email address is in cell K1. I have gotten so far as creating a PDF and having it saved to a folder, but can not figure out the email attachment bit. Below is the...

Good Morning/Afternoon for everybody. I work for this company where they have a spreed sheet with 4 tabs: 1. Data 2. Shipper 3. Emailer 4. Addresses. The objective of the workbook is to send emails to different people but filter data. (the addresses of the people is int he Address tab, the...

Apologies if this is in the wrong place, or has been asked before. i am trying to create code to enable me to have a sheet that would enable the user to automatically save as PDF, but only if the cell B6 is completed, this is the code i have. This asks for B6 to be completed but will then go on...

I have a workbook that consists of 3 worksheets. Right now the way I have the code set in the workbook people push a button and an email is created that dumps in the entire workbook. Well now this workbook needs to go out to multiple people at the same time so I've put those emails into the BCC...

I have this code, not sure how to post in the correct code format, but here is what i am looking to do. I am looking to take this code, make it so that I can have 4 checkboxes in my Userform. when any one of those 4 check boxes are selected it will attach a certain sheet (named the same as the...

Hi, I need some assistance with writing a code that will move the complete row if the value in the last column against the row is marked as "closed". This should be activated at the click of a button or through a short cut key. The closed items need to move to the empty row (the row after the...