Fill Form 2220 PDF 2022-2023

Hello this is Randy with Excel for freelancers and today is training we're going to be taking information from a table and automatically filling in multiple PDF forms with a click of a single button so please join us for this amazing training all righty let's get started so we're starting off with the table in this table we have a total of 10 names and this table basically contains basic information for our contacts in this case we're going to call them patients here's a reason why you might want to have this type of macro running let's say you work in a medical office and your boss asks you to complete patient intake forms for each and every patient coming in he asks you right out there their last name first name the address city state zip and email well now you could write each one of these out individually however if you have a list of names we can actually have Excel automate that through VBA to automate filling out that PDF and we do have a PDF form available so that we're going to be using that and we have it here right in here and now what we can do is that what we're going to do is we're going to automate filling in the information of using this PDF form using the last name first name address to the state and the fields and then what we're going to do is we're going to have it save that in a folder and now we can also have them print it out but in this case we're going to save it individual each one with their own individual and distinct name so let's get started first what we're going to do is we're going to...