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.
[TABLE="width: 6555"]
<tbody>[TR]
[TD="width: 182, bgcolor: transparent"]RPA#
[/TD]
[TD="width: 182, bgcolor: transparent"]RPA TYPE
[/TD]
[TD="width: 144, bgcolor: transparent"]NAME
[/TD]
[TD="width: 86, bgcolor: transparent"]OSID
[/TD]
[TD="width: 77, bgcolor: transparent"]SQDN
[/TD]
[TD="width: 140, bgcolor: transparent"]PP-SER-GR
[/TD]
[TD="width: 54, bgcolor: transparent"]TARGET
[/TD]
[TD="width: 87, bgcolor: transparent"]MPCN
[/TD]
[TD="width: 107, bgcolor: transparent"]# OF VACANCIES
[/TD]
[TD="width: 107, bgcolor: transparent"]Overhire(Y/N)
[/TD]
[TD="width: 107, bgcolor: transparent"]OH is No
[/TD]
[TD="width: 128, bgcolor: transparent"]CDP/PRD & SEQ NBR
[/TD]
[TD="width: 185, bgcolor: transparent"]DRUG TESTING
[/TD]
[TD="width: 149, bgcolor: transparent"]1st Lvl Supv
[/TD]
[TD="width: 167, bgcolor: transparent"]SUPV EMAIL
[/TD]
[TD="width: 164, bgcolor: transparent"]SUPV PHONE
[/TD]
[TD="width: 73, bgcolor: transparent"]1st Lvl Supv Seq
[/TD]
[TD="width: 149, bgcolor: transparent"]2ND LVL SUPV
[/TD]
[TD="width: 60, bgcolor: transparent"]2nd Lvl Supv Seq
[/TD]
[TD="width: 50, bgcolor: transparent"]FLSA
[/TD]
[TD="width: 39, bgcolor: transparent"]BUS
[/TD]
[TD="width: 161, bgcolor: transparent"]SAR
[/TD]
[TD="width: 146, bgcolor: transparent"]SENS
[/TD]
[TD="width: 142, bgcolor: transparent"]SPV STAT
[/TD]
[TD="width: 123, bgcolor: transparent"]Empl Supv
[/TD]
[TD="width: 172, bgcolor: transparent"]CAR FLD
[/TD]
[TD="width: 77, bgcolor: transparent"]CTRL MGD
[/TD]
[TD="width: 116, bgcolor: transparent"]CTRL MGD (Y/N)
[/TD]
[TD="width: 81, bgcolor: transparent"]Mission Ess
[/TD]
[TD="width: 62, bgcolor: transparent"]Mobility
[/TD]
[TD="width: 113, bgcolor: transparent"]MobilityReason
[/TD]
[TD="width: 145, bgcolor: transparent"]KEY/ESS
[/TD]
[TD="width: 48, bgcolor: transparent"]AFSC
[/TD]
[TD="width: 82, bgcolor: transparent"]PAS
[/TD]
[TD="width: 60, bgcolor: transparent"]FAC
[/TD]
[TD="width: 56, bgcolor: transparent"]PEC
[/TD]
[TD="width: 88, bgcolor: transparent"]POS STAT
[/TD]
[TD="width: 79, bgcolor: transparent"]TYPE APPT
[/TD]
[TD="width: 79, bgcolor: transparent"]NTE Date
[/TD]
[TD="width: 115, bgcolor: transparent"]REASON FOR NTE
[/TD]
[TD="width: 115, bgcolor: transparent"]AOC
[/TD]
[TD="width: 115, bgcolor: transparent"]Bargaining(Y/N)
[/TD]
[TD="width: 115, bgcolor: transparent"]BargPOS
[/TD]
[TD="width: 115, bgcolor: transparent"]BargStmt
[/TD]
[TD="width: 115, bgcolor: transparent"]POS Obligated
[/TD]
[TD="width: 115, bgcolor: transparent"]Political Appt
[/TD]
[TD="width: 115, bgcolor: transparent"]PCS
[/TD]
[TD="width: 115, bgcolor: transparent"]Annuitant
[/TD]
[TD="width: 115, bgcolor: transparent"]Incentive
[/TD]
[TD="width: 115, bgcolor: transparent"]FurloughIndicator
[/TD]
[TD="width: 115, bgcolor: transparent"]FurloughExcepted
[/TD]
[TD="width: 115, bgcolor: transparent"]FurloughExempt
[/TD]
[TD="width: 98, bgcolor: transparent"]Work Sched
[/TD]
[TD="width: 80, bgcolor: transparent"]PT Hrs p/wk
[/TD]
[TD="width: 100, bgcolor: transparent"]Telework
[/TD]
[TD="width: 77, bgcolor: transparent"]MAX# TDY
[/TD]
[TD="width: 77, bgcolor: transparent"]SSR(Y/N)
[/TD]
[TD="width: 77, bgcolor: transparent"]SSR
[/TD]
[TD="width: 186, bgcolor: transparent"]Type Incentive
[/TD]
[TD="width: 74, bgcolor: transparent"]APDP(Y/N)
[/TD]
[TD="width: 158, bgcolor: transparent"]Career Lvl
[/TD]
[TD="width: 187, bgcolor: transparent"]Critical POS
[/TD]
[TD="width: 186, bgcolor: transparent"]Career Cat
[/TD]
[TD="width: 82, bgcolor: transparent"]FIN STMT RQ
[/TD]
[TD="width: 93, bgcolor: transparent"]FIN STMT TYPE
[/TD]
[TD="width: 242, bgcolor: transparent"]FM Cert
[/TD]
[TD="width: 77, bgcolor: transparent"]EFF DATE OF ON RPA
mm/dd/yy or ASAP
[/TD]
[TD="width: 85, bgcolor: transparent"]LOCATION
[/TD]
[TD="width: 87, bgcolor: transparent"] FUNC CODE
[/TD]
[TD="width: 390, bgcolor: transparent"]COMMENTS
[/TD]
[TD="width: 121, bgcolor: transparent"]KIM
[/TD]
[TD="width: 176, bgcolor: transparent"]KIM EMAIL
[/TD]
[TD="width: 164, bgcolor: transparent"]KIM PHONE
[/TD]
[TD="width: 164, bgcolor: transparent"]FAX
[/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="width: 6555"]
<tbody>[TR]
[TD="width: 182, bgcolor: transparent"]RPA#
[/TD]
[TD="width: 182, bgcolor: transparent"]RPA TYPE
[/TD]
[TD="width: 144, bgcolor: transparent"]NAME
[/TD]
[TD="width: 86, bgcolor: transparent"]OSID
[/TD]
[TD="width: 77, bgcolor: transparent"]SQDN
[/TD]
[TD="width: 140, bgcolor: transparent"]PP-SER-GR
[/TD]
[TD="width: 54, bgcolor: transparent"]TARGET
[/TD]
[TD="width: 87, bgcolor: transparent"]MPCN
[/TD]
[TD="width: 107, bgcolor: transparent"]# OF VACANCIES
[/TD]
[TD="width: 107, bgcolor: transparent"]Overhire(Y/N)
[/TD]
[TD="width: 107, bgcolor: transparent"]OH is No
[/TD]
[TD="width: 128, bgcolor: transparent"]CDP/PRD & SEQ NBR
[/TD]
[TD="width: 185, bgcolor: transparent"]DRUG TESTING
[/TD]
[TD="width: 149, bgcolor: transparent"]1st Lvl Supv
[/TD]
[TD="width: 167, bgcolor: transparent"]SUPV EMAIL
[/TD]
[TD="width: 164, bgcolor: transparent"]SUPV PHONE
[/TD]
[TD="width: 73, bgcolor: transparent"]1st Lvl Supv Seq
[/TD]
[TD="width: 149, bgcolor: transparent"]2ND LVL SUPV
[/TD]
[TD="width: 60, bgcolor: transparent"]2nd Lvl Supv Seq
[/TD]
[TD="width: 50, bgcolor: transparent"]FLSA
[/TD]
[TD="width: 39, bgcolor: transparent"]BUS
[/TD]
[TD="width: 161, bgcolor: transparent"]SAR
[/TD]
[TD="width: 146, bgcolor: transparent"]SENS
[/TD]
[TD="width: 142, bgcolor: transparent"]SPV STAT
[/TD]
[TD="width: 123, bgcolor: transparent"]Empl Supv
[/TD]
[TD="width: 172, bgcolor: transparent"]CAR FLD
[/TD]
[TD="width: 77, bgcolor: transparent"]CTRL MGD
[/TD]
[TD="width: 116, bgcolor: transparent"]CTRL MGD (Y/N)
[/TD]
[TD="width: 81, bgcolor: transparent"]Mission Ess
[/TD]
[TD="width: 62, bgcolor: transparent"]Mobility
[/TD]
[TD="width: 113, bgcolor: transparent"]MobilityReason
[/TD]
[TD="width: 145, bgcolor: transparent"]KEY/ESS
[/TD]
[TD="width: 48, bgcolor: transparent"]AFSC
[/TD]
[TD="width: 82, bgcolor: transparent"]PAS
[/TD]
[TD="width: 60, bgcolor: transparent"]FAC
[/TD]
[TD="width: 56, bgcolor: transparent"]PEC
[/TD]
[TD="width: 88, bgcolor: transparent"]POS STAT
[/TD]
[TD="width: 79, bgcolor: transparent"]TYPE APPT
[/TD]
[TD="width: 79, bgcolor: transparent"]NTE Date
[/TD]
[TD="width: 115, bgcolor: transparent"]REASON FOR NTE
[/TD]
[TD="width: 115, bgcolor: transparent"]AOC
[/TD]
[TD="width: 115, bgcolor: transparent"]Bargaining(Y/N)
[/TD]
[TD="width: 115, bgcolor: transparent"]BargPOS
[/TD]
[TD="width: 115, bgcolor: transparent"]BargStmt
[/TD]
[TD="width: 115, bgcolor: transparent"]POS Obligated
[/TD]
[TD="width: 115, bgcolor: transparent"]Political Appt
[/TD]
[TD="width: 115, bgcolor: transparent"]PCS
[/TD]
[TD="width: 115, bgcolor: transparent"]Annuitant
[/TD]
[TD="width: 115, bgcolor: transparent"]Incentive
[/TD]
[TD="width: 115, bgcolor: transparent"]FurloughIndicator
[/TD]
[TD="width: 115, bgcolor: transparent"]FurloughExcepted
[/TD]
[TD="width: 115, bgcolor: transparent"]FurloughExempt
[/TD]
[TD="width: 98, bgcolor: transparent"]Work Sched
[/TD]
[TD="width: 80, bgcolor: transparent"]PT Hrs p/wk
[/TD]
[TD="width: 100, bgcolor: transparent"]Telework
[/TD]
[TD="width: 77, bgcolor: transparent"]MAX# TDY
[/TD]
[TD="width: 77, bgcolor: transparent"]SSR(Y/N)
[/TD]
[TD="width: 77, bgcolor: transparent"]SSR
[/TD]
[TD="width: 186, bgcolor: transparent"]Type Incentive
[/TD]
[TD="width: 74, bgcolor: transparent"]APDP(Y/N)
[/TD]
[TD="width: 158, bgcolor: transparent"]Career Lvl
[/TD]
[TD="width: 187, bgcolor: transparent"]Critical POS
[/TD]
[TD="width: 186, bgcolor: transparent"]Career Cat
[/TD]
[TD="width: 82, bgcolor: transparent"]FIN STMT RQ
[/TD]
[TD="width: 93, bgcolor: transparent"]FIN STMT TYPE
[/TD]
[TD="width: 242, bgcolor: transparent"]FM Cert
[/TD]
[TD="width: 77, bgcolor: transparent"]EFF DATE OF ON RPA
mm/dd/yy or ASAP
[/TD]
[TD="width: 85, bgcolor: transparent"]LOCATION
[/TD]
[TD="width: 87, bgcolor: transparent"] FUNC CODE
[/TD]
[TD="width: 390, bgcolor: transparent"]COMMENTS
[/TD]
[TD="width: 121, bgcolor: transparent"]KIM
[/TD]
[TD="width: 176, bgcolor: transparent"]KIM EMAIL
[/TD]
[TD="width: 164, bgcolor: transparent"]KIM PHONE
[/TD]
[TD="width: 164, bgcolor: transparent"]FAX
[/TD]
[/TR]
</tbody>[/TABLE]