I love that your videos pop up when I google how to complete a task in VBA. You are a great teacher - I just wanted to thank you!

You are so talent teacher I never see before. You are great. Thank you so much.

Dinesh you are truly a genius! I like so much what you do!! Thank you very much!!

Dinesh Sir you are simply great .....This video was great help to me ...Thank you very much for your noble job of publishing so informative stuff through your videos...I am your great Fan Sir !!!!

Thank you Dinesh, once again you have rescued me from a place where I was stuck

Congrats! Dinesh on reaching 100 K subscribers! You have helped me put food on my table to feed my family for many years with your teaching. I am thankful

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

Much needed tutorial. Thanx!

You're amazing. Thank you so much!

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)

Excelente! Just what i needed. Thank You.

Thanks so much. Very useful. Cheers

Takyar, thank you so much, really really useful. if I wanted to do this for specific worksheets within a workbook, how would I do that? I want to create a button that when the user clicks on it, it attachs sheet 2 and sheet 3, rather than sheet 1 which has the button on it? Thank you for your help Martin

Thank you. Very Useful

Good day thankyou for the tutorial Takyar I wonder if you could help a little more. When I run the marco all seem to work fine only when the email opens in Outllook I get new .TO and .Cc boxs appearing when I mouse over the excisting ones which in turn stops me from sending the email.

Thank you very much sir its a great help. .

Excellent !

Easy to digest tutorial. thanks a lot!

Thank you for the video. If I need to save all excel charts and only one excel sheet in one pdf (each chart /sheet is a page) how can I do this? let's say I have 1 excel sheet and 15 excel charts and I need the excel sheet to be the first page and then I need to email this one pdf. Thank you so much!

Thank you Very much sir, Great

Hi Dinesh, is there any guidance to change the script to include automation of the PDF at a specific time of day without having to manually run the macro? i would like to create a PDF and save it to a shared folder so i do not need to email the reports each time. Many Thanks in advance

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

i am having an excel file with list of email IDs & file path against each mail ID. please help me with macro which will help me to send individual email with said file as attachment

thanks a lot for the courses. sir do you have videos for dunning letter which i can generate thru excel and send via mail - outlook? if i have missed plz send me the link for the video. thanks.

Hi Dinesh, Thanks for the video. Do you have a way to export the spreadsheet as a fillable PDF form rather than a normal PDF using VBA? Thanks in advance. - Sumanth

Thanks mate!

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

Its very useful for me thanks lot..... If there have any option for multiple time auto email kindly advice

Brilliant, thank you!

Hi, it is perfect.. I am planning to add passowrd to the pdf file... can someone help me real quick please...

Hello sir, How can i save the selected range as pdf(like column A ,column L and column N only as pdf) in excel and send as attachment

Hi Dinesh, is it possible to attach multiple PDF with multiple tabs in the excel sheet?

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

Thank you!!!!!!

Thank you Very much. It is Very useful.

Hi Sir, hope u r doing well, kindly tell me , in ur video where i add for password in pdf while i send to employee , every pdf having own password..for every employee

thanks a lot Takyar, really helpful videos appreciate to help me in this I have data sheet with users information I want to save as pdf each user data and send it by email (separate sheet for each user) so, the VBA code should save each users information as separate pdf and send by email noting that I have more than 1000 users and all this should be done through the code thanks in advance

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?

Sir, I am looking for a macro that can convert multiple word documents into multiple PDF documents with a single click.. Will the below code help me? But I am getting error while running this code Sub Save_to_PDF() ' ' Save_to_PDF Macro ' ' With Dialogs(wdDialogFileSaveAs) .Format = wdFormatPDF .Show End With End Sub

This is great. Thank you for sharing. I was able to implement this code, and it brings up the outlook dialog box with my stated message and attachment. However, when I hit send, nothing gets sent until I manually open Outlook. I made sure to check the Outlook box under Visual Basic - Tools - References. I would appreciate any advice you can provide. Thanks.

Am I able to save my frmLookUp as a PDF although my frmLookUp (userform) was created with multiple sheets. I only want certain information to save and this is based on per customer after I search. I would like to save customer sales info as pdf after I search customer in my frmLookUp. NEED HELP

Hi I would like to Send email button, which will send the current sheet as pdf to one or two email addresses mentioned in the sheet

your a genius

Can this be used for windows live Mail? What changes to code would I need to make? Thank you in advance.

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.

Hello Mr. Dinesh, Thank you for the video and solution. I have a couple of questions: 1) Can it be sent to several emails at the same time 2) Can i automate the macro to run at a particular time to send the emails? - e.g. end of business day Thanks

could you please tell what to do if i want to save new pdf every time i run the macro instead of overlapping the current pdf file.??

Is that possible to assign a time or date to let this PDF excel file automate send by email in daily or weekly?

Hello Sir, When I am Run Macro Showing Error'1004' Please Suggest. Also my Outlook is 12.0

Great tool, thanks so much! Is there a way to generate multiple PDF and Email windows at same time if you had multiple sheets on the excel file?

Can we use something other than PDF? I would like to just export the work sheet as it self

Hi Sir, Great fan of you. I'm following your channel rigorously and implementing the lessons learnt; however, I'm stuck at the below part. Could you please help me in taking a screen shot of Userform and paste it in the body of the email?. I'm really tired of searching for this resolution across the google. Your help is much appreciated. Thanks in Advance.

Thanks a lot for your courses, Takyar, If I want to save as pdf only one page in the sheet that would contain 3 pages. example : save as pdf page 2 or from cells a23 to g65. Thanks a lot for your help. Laurent

Hello Dinesh, I wrote my first code with your help and now I think I'm hooked for life. Your videos have taught me how to build a command button which converts my excel to PDF dependent on two cells. Now I would like to email this PDF which I created. I watched this video but I'm stuck on the myattachments part since my pdf name is created and has the name = Path & FileName1 & "_HF_" & FileName2 & ".pdf". What should I write under .myattachments. Thank you so much.

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 ?

DEAR SIR, I have made one user form(for my Off Job) and converted into pdf using your code's its working fine, Thanks for the video. I have given demo at my off and got good feedback's and appreciation. With the officer's feed back i have to circulate only a message with respective people using Thunderbird only. Can you help me. I will be waiting for you reply Thank you.

Hi Dinesh, I tried this one and it worked really well. Thank you very much. Can you kindly help show how we can save it such that there is a user interface to put in a specific filename please. Hope you can help please. Thanks.

Hi, Dinesh thank you for this tutorial, I am new to VBA and find it so exciting to learn. I tried this code and works really good... I have a question, if I want to name the converted pdf as per the Active Sheet Name, how to do it ? And also if I want to send the email to the email entered on a cell or multiple emails, is that possible? If anyone can help ... please... Thanks in advance.

Hello and thank you for your video. Can you please tell me where can I add to export only one of the sheets to PDF? I am working on a multiple sheet Excel file. Thank you once again.

Excellent post! I just need your help with something. How can I modify the code in order to make the email address variable. This idea changes the ".to" line and "myAttachments" Line because the name of the file varies. Thank you very much!

Diesh, Great video Could you tell me what the parameter 0 in the line set OutlookMailItem=OutlookApp CreatItem (0) does?

Hi sir! I m deserate for a help. Can you help me to automate multiple word files/pages to multiple pdf password protected? I've been looking up in the internet for years, i still have found a solution. My job is to create letter from word using mailmerge for multiple individual. I have to manually set password for each page with different password. Can you help me automate this? Please helllp

Hello SIr Great Video, My Question is that can i send full fill like all sheets . for the time being i am able to send only the current (One Sheet) not full Sheets of the file at-once

sir, how to export pdf in multiple specified work sheet

Hi Dinesh. This video is great! My question is: how do I change the code to refer to a cell for the Filename. So specifically, the "test-save" part i would like to refer to a cell instead of hard-copy it in the vba code. The cell will include the supplier name and the invoice month in question. It would be greatly appreciated if you can help me out. Regards, Lisa

Dr. Takyar, this is great, however, how would you go about automatically changing the file name you are saving it as? Example: If the PDF was saved daily, how would one save it as "30 Apr Report" then tomorrow saved as "1 May Report" and so on?

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?

this is very nice. What if the name of the pdf changes every time & recipient. The solution could be to just bring up the outlook email and no not write the send code then I will be able to change the recipient's name every time. that part is easy but what about the pdf as my macro allows me to save as pdf and brings up the save as for me to enter a specific location to save my pdf forms. This can be a task but I thank you for the inspiration and I will try this

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

Also I need a macro to retrieve invoice status from the website which has login details

i can't do it with excel 2007 in windows XP. please help me.

Thanks for your video. How would I make it work in my instance? I have code that saves a file using time and date stamp every time a command button is pressed (saves to the desktop), but every time I refer to the saved file as an attachment, I get a 'the file could not be found' error message. My problem is how to refer to the saved file when adding code to send the email, since the file name is dynamic? Any help would be appreciated, thanks!

I am getting error code of run time error 76 in chdir please help me to resolve the same at the earliest

Hi Dinesh.. I do have many PDF files where 3 PDFs each needs be merged and saved in a different folder with first PDF name.. do we have a macro for that.. I do have Adobe merger by selecting the PDFs and right click and combine.. but need to have a Macro to merge more than 300 pdd

When I send the file to another user it doesn't work has an error, is that because of the file name being created using my extension?

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?

hello sir, i have work sheet with a list of names , what i want now is , searching for a specific person name from that list and open the file related to that person in pdf and the file related to that person will be stored in my computer . I want a button like "open in pdf" in front of search result . how to do it sir please help

Hello there! one quick question, does this run on iOS? and instead of Outlook with Mac Mail? Thanks!

thank you for this tip because it is coming according to my needs I just ask myself the following and your response will occur l

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.

can we generate automatically appointment letter by data(name,post,address,koining etc)in excel sheet(employee master sheet) with a single button,and save it in a format of sr no. name_designation.doc.pls make a video on tht as well.

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

hi Dinesh, can you please also help me with this. Instead of attaching a file as pdf, I need the file look like as screen shot of that template from an excel file that will automatically look like part of the body of the email. is that possible? thanks in advance.

Hi Dinesh Sir, Good morning, My name is Deepak and stay in small apartment in Bangalore. I need your help to create excel to generate and keep track of receipt of monthly subscription fee collected from owners and send them pdf receipt to their mail id which is mentioned in list.. please help us if you have created such any macros.. it will help to minimize lot of paper. thanks in advance. please help

Hi Dinesh, Thank you for this great tutorial. I have a problem I'm encountering and hope you can help. in ChDir i replaced the specific location with Thisworkbook.Path & "\" so that it will always export the PDF in the current folder it is in. This is because I created a sales quote template and will always copy paste it into a new client folder to create their own quotes. As such i want to ensure that everytime i run this code it a) exports the active sheet to PDF in the same folder as the excel file and b) attaches that exported PDF to the email. i've figured out most of this on my own but the problem i'm facing is when i'm trying to get the PDF to attach to the email. how do i tell it to find the pdf in the same (variable) directory? so far i've tried myattachments.Add ThisWorkbook.Path & Range("'Costing'!C1") & ".pdf" but it says it cannot find it, even though the PDF is there. thank you and i appreciate you taking the time to read this if you still are :) Ray

very useful video, how can I add button in the excel sheet so if I press the button it will export the PDF file?

Hello, how can I improve the code, to make sending reports every day at 9:00. Automatically without my attendance?

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)

Hi Dinesh can you please share a Link where you have started on line courses from scrap.

I have an excel file with some data in it and I convert the excel file to CSV so that I can import the required data from CSV File to PDF Form however to complete each PDF Form I need to import the records from CSV File again and again. I wanted to know if there is a way out to fill multiple PDF Forms in 1 click. Kindly help.

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 need to do this with ms access

Dear Mr. Dinesh, First of all thank you very much for this brilliant explanation. But could you please explain us how to set up a VBA code in the case when user doesn't have Outlook or any similar applications. In my case I don't have permission to install any application like Outlook or similar so I have to use only hotmail. Please I would be grateful if you might be able to help me write a VBA code for this case. Thank you very much Kind regards

This is very nice indeed and good information. Keep getting errors on: Set OutLookApp = CreateObject(Outlook.Application)

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

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

Hello, First thank you for sharing all this information. I have a main userform that branches out to two other forms and I need to save the Userform as a PDF and send it by email. The email attachment sent out must be the main Userform and access the other two Userforms. Example of my userforms: Main userform input all the customer data then I have a two comand buttons, each one opens a Userform for data entry and user returns back to main Userform.Can you help me with this? Thank you for you cooperationElsa

Hi Dinesh Kumar Ji, I need a code for exporting excel data to a pdf, and that pdf can not be editable by any ony, i saw u r video its helpful to me, but that pdf is editable by using pdf edit software, could you please suggest me how to create uneditable pdf through macro

Hello Dear, My i know if i have multiple email to send with multiple attachment how i can use vb micro code its possible to use cells value as file name to save the file as a pdf and can use attachment also as cell value . thanks in advance for your help.

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 :)