Automate Excel To PDF & Send PDF Document As Mail Attachment

Thank you for this Dinesh. My question is how to express formula to send the payslip to the respective email add...considering i have an email address column in my active sheet.Thank you so much.

Thanks Sir !
Good lecture , well done.
Thanks alot 🌺

awesome video. how to add on in this vba with adding password on the exported pdf? also is there a way to automate different password to different client or recipient name?

Thank you. This solved a problem I have bee struggling with ever since I created my invoice

Hello Mr Takyar, great video !!! In order to send an email I need to have my Outlook already open. Otherwise this HTML Emails sits somewhere and waits for OutLokk mail to be opened. How can I deal with that ?

i want to prepare a checklist for team and until the whole team signs the checklist the macro should throw an error while sending the email. Sir it would be really helpful if you can please guide me with this

I have created a macro in my personal workbook but when I saved it(macro enabled) in a shared path my teammates are unable to run the macro and there is no VBA found in their system. Please help me to fix this

need invoce no. in subject line

How to do iteration for multiple files in excel ( for loop ? )

I have simply followed Your instructions and all works perfectly ! Thanks for sharing Your knowledge.

If I want my pdf attachment with today's date , what should be done??

Air kya hum ise whatsapp par pdf share karna chahe to kaise kar sakte hai??

Hi. Thanks for the video. Is there a way to export whole workbook instead of one sheet. Thanks 😊

Sub Sanction_Letter()
'
' Sanction_Letter Macro
'
ChDir "D:\Sanction Letters"
ActiveWorkbook.ExportAsFixedFormat xlTypePDF, "D:\Sanction Letters\" & Sheet2.Range("Companyname").Value & ".pdf", , , False, 2, 11, fasle

Dim OutLookApp As Object
Dim OutLookMailItem As Object
Dim myAttachments As Object


Set OutLookApp = CreateObject("Outlook.application")
Set OutLookMailItem = OutLookApp.CreateItem(0)
Set myAttachments = OutLookMailItem.Attachments

With OutLookMailItem
.To = Sheet1.Range("TO")
.CC = Sheet1.Range("CC")
.Subject = "sanction letter for sheet2.Range(companyname)"
.Body = “Pleas”
myAttachments.Add "D:\Sanction Letters\ & (sheet2.range(companyname).value & .pdf"
.send

End With

Set OutLookMailItem = Nothing
Set OutLookApp = Nothing

MsgBox ("Sanction letter has been generated successfully")

End Sub



getting an error cannot find this file, verify the path and file name are correct- please suggest how to write query for file path.

how can i directly directly generate salary slip from excel as PDF as send as gmail attachment without using Microsoft outlook?

Thanks a lot sir, this has helped a lot... God bless you!

How can I do it via IBM notes

Hi Dinesh
Every coding is perfect but sending mail is not received in the recipient mail address. Please help me to get a solution. Thank you. Sujay

Very good video thank you!

One question, how can I automate this process without me having to be in excel? I would like this email/pdf attachment to automatically send to staff 30 days before a particular date in the Excel document?

This would serve as an automated email reminder from Excel that a task we are tracking in Excel has 30 days to be completed.

Thanks

Its so helpful for me but how to do when alots of person with different mail ID to send pdf file like this? Plz guide me.

how to upload a pdf file and save in to a folder using VBA

Dear Dr Takyar,
Is there a way to print a PDF file with VBA? I am using windows 10 , 32 bit version, and excel 2010. I searched much, but unable to find a working method.
Thank you.
Piyal Fernando (Sri Lanka)

Thank you very much Dr. I met your videos only in last week and they help me to improve my knowledge in VBA =, Thank you so much again. Piyal Fernando (Sri Lanka)

I am using ms excel 2007 and word 2003 when I am copying your vba code its not working kindly fix it

Sir, very useful but i am getting error in the line : ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:="C:\EXCEL_PDF\test_save.pdf”, OpenAfterPublish:=True"

Invalid procedure call or argument.. can u pls help me out

Could you please help for generating multiple pdf through drop down cell value and email it with attachments and as email body as an image or snapshot of that pdf.

What if if we have multiple sheets ?

HI thank you for sharring!

I have develop you code a little bit and when i save i gets different PDF files names. Therefor i cant send the PDF i have just createt, only the one named in the code - How can i send the newest add PDF add file insted, so i send the right one out :)

how do I change the mail to equal an email listed in the document?

Can we make PDF uneditable ...???

How to replace email client as lotus notes

Hi sir I need mail merge pdf with password protected is there any option do it.

Hi sir
I am not able to open outlooks, it's going debugging always.
Although pdf created successfully
Thanks

Dinesh, I could run the VBA, issues I face, I shall like to pick up variables like File name, email address, subject from the excel sheet directly, or else what is a point if I need to keep on editing the VBA code for every memo I send? Will you bale to suggest how to bring the cell value to above?

How can we upload multiple excel file from local path to SharePoint url using VBA please suggest.

Dear Sir
Can I send it from my Firefox application.

Hello Dinesh,
I'm getting the 404 Error-Object not found by the line: myAttachments.Add "C:\Users\Sasu\Desktop\file-Test.pdf"
PDF Creation works fine, but the sending nis ot working. any idea what I might be doing wrong?
Thx btw, you're doing a great job!

Hi Denish. I am trying to transfer my Invoice to PDF but that will not work. This is the Code I use.

Private Sub cmdPDF_Click()
Dir "C:\Users\Desktop\Database"
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"C:\\Users\Desktop\Database\Incoice-save.pdf", OpenAfterPublish:=True

End Sub
And it will not either take ChDir
I don't know if it has something to do with I using Windows 8

Sir how to send any PDF attachments by email using VBA code

Hi Dinesh. This was just what i was looking for and i get it to woke just fine but I have one problem and i can't fine the solution anywhere so i relay hope you can help me. The Excel fill is online and is used by multiple users. how to write the code for multiple ?

I have tried with

Sub Send_MAIL_PDF()
ChDir "C:\"
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"C:\Users\Application.UserName\Desktop\Lopc.pdf"

Dim OutLookApp As Object
Dim OutLookMailItem As Object
Dim myAttachments As Object

Set OutLookApp = CreateObject("Outlook.application")
Set OutLookMailItem = OutLookApp.CreateItem(0)
Set myAttachments = OutLookMailItem.Attachments

With OutLookMailItem
.To = "........"
.Subject = "LOPC redo"
.Body = "REDO på LOPC"
myAttachments.Add "C:\Users\Application.UserName\Desktop\Lopc.pdf"
'.send
.Display
End With

Set OutLookMailItem = Nothing
Set OutLookApp = Nothing



End Sub

But it doesn't work
Please help

Best regards Anders

Hi Takyar, it is a brilliant video. I have two questions. 1. In Subject it is possible to add present date and then followed by data. 2. Can i use the same procedure for word.

I have a problem with the code ChDir that says Argument not optional . can anybody please help about that ?

but sirs if my excel consist there is a co logo will it capture?

yes perfect. let me try tommorrow. I have mutil task.

I have an error; Sub and Function Compille erorr. How can ı fix ?

Hi sir,
Am generating XML file from excel instead of saving the generated XML. I have to send via outlook. How I should proceed with it. Please advise

How to save Excel to pdf with save dialog.? Please

Easy to digest tutorial. thanks a lot!

This is awesome. Suppose I wanted to use my excel data as the name to save the PDF file how would I do that inVBA?