Skip to main content
A
Anonymous
July 26, 2019
Answered

Exporting ONLY the mail merge data from PDF to excel

  • July 26, 2019
  • 1 reply
  • 2233 views

Hi all,

A colleague of mine (who is now on holiday) has set up 16 tranches of letters to go out (around 2000 per tranche) each day, to different companies. We have realised halfway through this campaign that there are duplicates within each tranche. Not sure how many but could be hundreds - we don't want to send the same company multiple letters so need to export a list of each company that is within each 'tranche' (which are separate documents).

We have colleagues who can use Acrobat to export PDFs to excel so I can complete a lookup within excel to search for duplicates, unfortunately it just exports the whole letter format into 1 cell which isn't going to work. Is there a way to export only the mail merge data? In this scenario that would be the company name/address. That way it would show me the name on each cell and I can complete a lookup between all the different documents.

Thank you in advance!

This topic has been closed for replies.
Correct answer try67

Try this: Open a fillable form and then look under Edit - Form Options. It should appear there too, I believe.


See also: Collect and manage PDF form data, Adobe Acrobat

1 reply

try67
try67
Community Expert
July 26, 2019

If that data exists within form fields, sure. You can use the Merge Data Files into Spreadsheet command in Acrobat to achieve it (look under Tools - Prepare Form - More). However, isn't that just the same as doing it directly on the original Excel file?

Just remove the duplicates there and then generate new PDFs...

A
Anonymous
July 26, 2019

There is no "original excel file" anymore. The colleague did not save the data he mail merged after doing so. This is why it's causing so much of an issue.

So within Acrobat, just 'merge data files into spreadsheet' will take just the data used for the merge and put it into a new spreadsheet?

try67
try67Correct answer
Community Expert
July 29, 2019

Try this: Open a fillable form and then look under Edit - Form Options. It should appear there too, I believe.


See also: Collect and manage PDF form data, Adobe Acrobat

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices