Is there someone out there that can explan to me how to import data from an excel spreadsheet to pdf?

Question

I need to import data from an excel file containing address information into a mailout in pdf format. I can do this easily in Word, but am encountering problems with the pdf. Sort of like a mail merge but not in Word. I have fields that contain first name , last name, address 1 address 2, city, state , zip. I need to import these fields in and print thee file out to mail. also, how would i tell it to print the doc multiple times, and have all the addresses come sequentially. once again, like a mail merge.

Answer 1

You can create a PDF file by using a shareware program called pdf995. This software creates a virtual printer which prints to a PDF file. Simply create your document in whatever program and print to the PDf995 printer.

Answer 2

You would probably have to have Adobe software (not just the Reader) operational on your computer so that the actual Adobe file could be opened so as to get to the actual data. The PDF format was intended to allow the sharing of the product but not the actual data. You could TRY dragging over ONE of the rows and TRY a cut-and-paste into Excel bu I strongly suspect that will not work. Rishita apparently didn't understand your question, since he pointed to a spftware package that goes the OTHER way and wouldn't help you at all.

Answer 3

Go into "File" >> "Print". From the drop down box, select whatever PDF conversion program you have, and it will output the spreadsheet as a PDF.
There are lots of free PDF conversion programs (ie: PDF4U.)