Mail Merge Data From Excel into Fillable PDF

onlyonekj

New Member
Joined
Jun 27, 2019
Messages
18
Hello,


I have a fillable pdf document and want to mail mergeinformation from an excel spreadsheet. The field names on the pdf document and the headings on the excelspreadsheet have the same name. I havebeen successful doing the mail merge from an excel spreadsheet into a Worddocument, but cannot seem to figure out how to do this in a pdf document. My excel spread sheet headings arebelow. Can it be done? Thanks.





RPA#

RPA TYPE
NAME
OSID
SQDN
PP-SER-GR
TARGET
MPCN
# OF VACANCIES
Overhire(Y/N)
OH is No
CDP/PRD & SEQ NBR
DRUG TESTING
1st Lvl Supv
SUPV EMAIL
SUPV PHONE
1st Lvl Supv Seq
2ND LVL SUPV
2nd Lvl Supv Seq
FLSA
BUS
SAR
SENS
SPV STAT
Empl Supv
CAR FLD
CTRL MGD
CTRL MGD (Y/N)
Mission Ess
Mobility
MobilityReason
KEY/ESS
AFSC
PAS
FAC
PEC
POS STAT
TYPE APPT
NTE Date
REASON FOR NTE
AOC
Bargaining(Y/N)
BargPOS
BargStmt
POS Obligated
Political Appt
PCS
Annuitant
Incentive
FurloughIndicator
FurloughExcepted
FurloughExempt
Work Sched
PT Hrs p/wk
Telework
MAX# TDY
SSR(Y/N)
SSR
Type Incentive
APDP(Y/N)
Career Lvl
Critical POS
Career Cat
FIN STMT RQ
FIN STMT TYPE
FM Cert
EFF DATE OF ON RPA
mm/dd/yy or ASAP

LOCATION
FUNC CODE
COMMENTS
KIM
KIM EMAIL
KIM PHONE
FAX

<tbody>
</tbody>
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Forum statistics

Threads
1,215,219
Messages
6,123,684
Members
449,116
Latest member
HypnoFant

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top