PDF List Scrubbing Help

3 Replies

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

I do this for work all the time using AdobePro. Under "save as" you can havr it convert to word, excel or an image. Sometimes there is still a little physical cleanup to do, but 9 times out of 10 it works perfect. If you want to send me the list I can convert it for you.

Free eBook from BiggerPockets!

Ultimate Beginner's Guide Book Cover

Join BiggerPockets and get The Ultimate Beginner's Guide to Real Estate Investing for FREE - read by more than 100,000 people - AND get exclusive real estate investing tips, tricks and techniques delivered straight to your inbox twice weekly!

  • Actionable advice for getting started,
  • Discover the 10 Most Lucrative Real Estate Niches,
  • Learn how to get started with or without money,
  • Explore Real-Life Strategies for Building Wealth,
  • And a LOT more.

We hate spam just as much as you