How To Create Fillable PDF's, Automatically Fill Them With Excel Data & Email Unlimited Contacts

Dear, You almost covered everything in thoses courses , I wonder what else you gonna teach us. Many Thanks 😅

Can these forms be completed on a cell phone?

Awesome video!

Hallo, I have Excel for Mac and the programming does not work. The first mistake pops up at the point -.Title "select PDF Form"-. (Compile error: Invalid use of property) Any ideas? Thanks

Loving this Randy. Same way -
I am just looking the same in excel file. I am having a fillable template in Excel sheet and I have another table in next sheet. This tillable template in excel will fill from the data in next sheet in a table. It’s nearly 1000 data. I wish to create 1000 separate excel sheet in a folder. And same time - I am looking for a feature where I can review one single data and send an email directly. Please do let me know - if you have something like this in excel not PDF ?

Thank you! Can you do more training like this. Starting from the beginning this training was awesome

Hi Randy, just completed this and it works amazing! I just have one question. Do you think there is a way to lock the pdf files after you've made them? i need to send out a few hundred and it would be nice if the receivers couldn't edit them. Thanks!

I’ve recently started watching your videos and they’re really amazing, thank you so much!

All the steps worked great I’m just having trouble with the AppActivate.. I’m using PDF XChange Editor, and can’t figure out how to make it go back to it to fill out the second form.

Thank you for sharing the knowledge. So helpful.

Sir, How can we fill a PDF form with data from multiple rows of excel. Like data with specific dates or any condition.

Hi Master, I have an issue need your help and advice.
How can code to get data from excel file when I input a Keyword, then I enter or click a button --> all remain fields in pdf will be automatically loaded depend on the Keyword.

Thanks

sir what are the shortcuts for microsoft edge if we open pdf in microsoft edge?

This is great, thanks so much. Is this in your workbooks bundle? Is there a way to modify this to select multiple different forms (eg request for loan quotes from different banks) where we need to fill in the same standard details? ie a set of multiple forms, filled out for multiple customers

I love all of your videos! I'm just getting started in the VBA world. I'm following allowing very slowly and going back over and over. But I'm getting an error message that's holding me back from moving forward. I just joined the Facebook Group but I also wanted to see if you could help me out here. On line .Filters.Add "PDF Type Files", "*.pdf", 1 I'm getting a "Run-time error '438': Object doesn't support this property or method error message. Any idea why I'd be getting this message? Thank you for your help and I look forward to diving into all your videos and joining your website.

This video was very helpful. Thank you! However, I am running into a problem: After the macro completes and goes to the next row, it resets the PDF form successfully, but then starts on a random field towards the end of the PDF file rather than starting at the first field. Any ideas why this is happening? It seems that tabbing on the Foxit PDF Reader starts on the first tab position of the current page rather than returning to page 1 (my PDF form has two pages).

Very good video 💖💖

Beautiful video

nice

TNice tutorials person speaks the truth, the whole truth and notNice tutorialng but the truth

Nice

Nice video

has anyone had this error and was able to fix it? "Object variable not set (Error 91)"

Is there a way to do this one line at a time? Like if we select a check button or something in excel and it will only auto populate those lines into multiple pdf files?

Hello. Great videos you have here.
I am trying to make a fillable PDF registration form and I can't get monetary cells. Once the document is transformed into a PDF, the cells are fillable but I cannot make them monetary nor align them nicely.
I saw the 'Create Word Documents & Emails From Any Excel Table, With Number Formatting, Without Mail Merge' video but I'd like to do all of this number formatting inside of a fillable PDF.

Do you have another tutorial that shows how to make a fillable PDF with monetary cells?

Hi there, Great work. The big problem for me is that it cant fill the pdf with Greek Strings. It can be filled with dates or numbers but not with Greek strings. Any ideas ? Thanks in advance. BTW for Acrobat Reader you need to activate the filename and not the program itself (Acrobat) at thee end so you can close it after.

Hi, thanks for the video tutorial, very useful.
I had a problem, I had a column of data in excel that each cell contains WORDS, NUMBERS and SYMBOL, eg: One Thousand (1,000.00).
However when I use the code: Application.SendKeys .Range("L" & CustRow).Value, True
It does not fill in the ( ) in the PDF form. Instead, it only fill up: One Thousand 1,000.00.

May I know how can I make it showing the ( ) in the PDF form? Anything to do with the vba code?
Thanks in advance :)

Excellent tutorials - many thanks

Thank you so much for sharing your knowledge which helps me so munch in understanding how macro works. I see it so helpful!! I have a question, can you also share a video about how to convert values in template to text (paragraph) by clicking a “submit” button?

Is there a macro for that? If so, I would truly appreciate if you could share! Thank you 😊

This is extremely helpful. I’m curious tho is there anyway to allow it to run without seeing it all happen? I noticed I cannot click anything else on my second monitor when this runs which is fine but does it have to show all the windows?

Hi, Had a Question about once you create a PDF that you can edit? Can the areas that have subjects with Questions to then be answered, then link to say the botton of the PDF with a summary of each subject so you dont have to re type the information that has been say ticked and filed in on each subject?

Sir your tutorial are just awesome. Is there any way that i can fill a excel form from another database just by entering a single number.( For eg i want to autofill a person's details in a form just by entering his Name)

Hey Randy, I hope you are doing well. I wanted to create unique pdf from excel data, however, the pdf template remains the same and just the values in each excel cell are different. I don't want to mail the pdfs but want to store them in a local folder, is that possible?

Thank you so much for this tutorial! Is there any way that for example you could add the students picture if needed?

Excel hangs everytime I run the code. Could someone tell me why ?

No other word, Superb!

Excuse Me Randy, please explain me or you can add last minute of this video how to automatic send (without sendkeys). Because i wanna use outlook (not gmail)
Thank you for you attention

Slow down and complete your thought!

The .cells(temprow, tempcol isn’t working and giving me a 1004 error for save templates. Any help?

Thank you, sir, for greate tutorials.
the question:
When I fill out a PDF form in Cyrillic, I have a problem with two letters. These two letters are located on the keyboard in the character position [ ]. When any of these characters occur, the program stops further loading letters. Thanks in advance for the reply

Do you know of a way to validate the email addresses in excel? Validate meaning ensure the email address and domain are real, not just formatted correctly.

It's so mesmerizing !
I used to use Excel intensively in my work, I know that VBA can do a lot of things but my lack of knowledge of all those functions ruins every tries...
I can of course have a "good final result" but always have the feeling it must be easier to program a macro "your" way than my way :-)

Congratulations Randy, seriously you remember my Access teacher... man he was soooo good too.

Hi Randy,

Your time and efforts are extremely appreciated and I am so thankful to you.
I wonder if there is a way to change a picture of an existing image in a PDF file using vba?

Have a great time

Your stuff is amazing!!!!! :)

Debug: Method 'Range' of object '_Worksheet' failed
Highlighted: .Cells(TempRow, TempCol).Value = .Range(.Cells(9, TempCol).Value).Value 'Bring down values from form into table
I need help debugging! ***My values are in row 9 not 15

Hello Randy!
Thank you so much for such an amazing video. I am new to your channel. All that content is appealing to me for what was in my head to design. I am curious to know if we can use any code to fill in “radio buttons” and “check boxes”.
Thanks

Hi... I have another Question... I am getting Error Messages under PDF Marcos Modules - If Dir(NewPDFFile, VbDirectory) <> "" Then Kill (NewPDFFile) Also Under Create Email - I am not able to Add With Outmail - VBA Error Message states "This Action will reset project, proceed anyway?" Please help. Thanks!!

Thank -you for the great video...Is there a Short Cut for Adobe PDF or should I just use the same PDF software that you are using? I can not find the short cut keys to clear the form in Adobe PDF... as you may know , Adobe seems to be online in August 2020. Keep Up the Great Work & I look forward to your reply. WJA

Hi Randy I hope you're doing well...do you think this process would work with Adobe Acrobat Pro? Would the text fields there be compatible in the same way as text form fields from PDFEscape for example? Not keen on using PDFEscape.