need some help on populating the cells in an excel form for 600 employees
The original dcument is in pdf format and i have an excel spreadsheet with all of the information i need entered.
Hello and thank you for contacting us, a paid expert support site. My name is XXXXX XXXXX X'X be glad to assist you with your issue.
Would you be able to send me everything I need so I can review?
how can i attach the two documents?
The best way is to use Wikisend: http://www.wikisend.com/
Just provide me the file ID or URL of the files after you upload them
http://wikisend.com/download/357294/New Waiver file.pdf
and now for the excel spreadsheet with the information.
is this secure?
very sensitive info.
Yes, only I can download it since I will have the FIle ID
i tried to save it as an excel document but this is what i got..
http://wikisend.com/download/435422/New Waiver file.xlsx
http://wikisend.com/download/224864/employee info for waiver form.xlsx
here is a sample of the info for a few of them..but the total is about 700
how do we look? do-able?
Sorry, having some chat issues.
Hrm, let me see what I can produce.
Ohh I see what you are trying to do.
Not entirely sure that is going to be possible. Those forms typically need to stay just as they are (not converted)
I don't know of a way to mail merge with a PDF, thogh
:( ok. Should i try and recreate the form in excel? that way a v look up may help?
the mail merge was going to be using a general excel spreadhseet with badge expiration dates to pop up on my outlookl calendar to notify employees.
No, it would be pretty difficult to recreate that form in Excel.
I might be able to convert this to a PDF form. Not sure if we can somehow import the information in.
You might need to purchase a program to do it.
i need to step away from my desk for about 30mins..
my cell is(NNN) NNN-NNNN. if you have any questions..
It's software - I might be able to make this into a fillable form, then you can use software to import the information in
oh i see
let me see if my IT has it
they have the license for changing the pdf to a fillable form
ok can we reconvene in about 30 mins?
ok i am back.
should i go ahead and request the software?
If your IT department wants to do it, the PDF needs to have fields added, then you then you can use that software (form filler) to fill the fields in.
See the page I linked you how on
do i need to do that for each individual person?
do i need to do it for each individual person?
No, there is an import feature (#5)
on that page
any thoughts on the mail merge from the excel spreadsheet for the expiration dates o outlook calendar?
I've never heard of such a thing, to be honest. I don't think there would be a way to do that.
actually there is such a thing..i started to do it but got side tracked.
I wasn't aware. If you have a solution then you might just stick to that.