Using SendKeys Paste to autofill PDF forms doesn't copy line breaks

[peterchclarke]

Hello Everyone,

I have a dataset that I would like to paste into a PDF form that I have made. I am building a module to eventually save the forms in a specified folder. I am using SendKeys function so that after opening the PDF file it tabs through the various fields and pastes the results. The dataset is large, circa 25000 items.

I have had to use a copy paste function as below due to the length of the strings, however this means the line breaks aren't included and some of the data is almost unreadable.

Please Login or Register  to view this content.

I have tried using a replace function to change the Char(10) and Char(13) as well as other breaks to <br> to no avail - it simply prints <br> in the form.

I've attached both the form and a heavily redacted dataset.

Any help would be appreciated!

[Keebellah]

Hi, I haven't looked at you files yet, but have you considered coping the results you want into a temporary worksheet; format it as you would want to be when printed and then save this sheet as a PDF file? After that you can just delete the worksheet.

[Keebellah]

I did a quick Google search and came up with this ite, maybe there's something here
https://www.excel-first.com/use-exce...f-form-fields/