PDF List Scrubbing Help

[Jason Rogers]

Hello All, I am in the midst of getting my first direct mail campaign off the ground. The list I have is in PDF form and not set up as a form or table. I want to do a mail merge using an Excel spreadsheet and a Word letter. Because of the layout of the data in the PDF any attempt to copy and paste leads to a jumbled up mess that is hard to even make sense of. At this point I am grinding it out copying and pasting. By my estimates it will take me over 80 hours to compile my list at this rate. Does anyone have any ideas as to how to speed this process up? I am pretty proficient with Excel and have used VBAs in the past to expedite long repetitive tasks. I can’t quite figure one out for this. Any thoughts would be greatly appreciated! Jason Rogers