Convert Drop downs to text and copying to Excel?

reidthaler · #1 09-01-2016, 11:49 AM

I'm using drop downs to fill in tables, then mail merging it. I need to save a table as a CSV format, so normally, I would just copy and paste in Excel. But it doesn't work, because the drop-down fields don't copy over into Excel.

The only workaround that I can think of, which I think is risky would be to convert it to a PDF and then OCR the document into Excel, but worried I could introduce errors.

So are there any workarounds for being able to convert drop downs to text?

Note that I'm using Word 2003. Yes I preferred over the newer versions. Is this issue solved in newer versions? Anyone have any great ideas.

Thanks so much!

Reid

gmayor · #2 09-01-2016, 10:45 PM

Are these legacy form fields or activeX fields?

reidthaler · #3 09-02-2016, 06:34 AM

Quote:

Originally Posted by reidthaler

I'm using drop downs to fill in tables, then mail merging it. I need to save a table as a CSV format, so normally, I would just copy and paste in Excel. But it doesn't work, because the drop-down fields don't copy over into Excel.

The only workaround that I can think of, which I think is risky would be to convert it to a PDF and then OCR the document into Excel, but worried I could introduce errors.

So are there any workarounds for being able to convert drop downs to text?

Note that I'm using Word 2003. Yes I preferred over the newer versions. Is this issue solved in newer versions? Anyone have any great ideas.

Thanks so much!

Reid

Whatever is produced by word 2003. Is there a choice? Do i have to switch to word 2013?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Lock specific drop downs on a Word Document	icarrus	Word	1	09-30-2015 02:07 PM
Drop Downs	Suray1911	Excel	1	09-29-2015 10:31 PM
field shading for drop downs	rbd50	Mail Merge	3	03-31-2015 09:52 PM
Drop-Downs: Run Macro on Exit	Andrew H	Word VBA	15	11-16-2012 08:34 AM
Please help me with drop downs in Excel 2010	mhays	Excel	6	01-16-2012 09:29 AM