*** Text Database Entry ***
"","First name:","Middle name(s):","Last name:","ContactID:","Mobile number:","Email address:","Date of birth:","Select all the 'Brands' you would like us to investigate: (only tick those you have had an account/relationship or borrowing with)","","Did you ever hold a joint account with somebody for the above 'Brands' you selected?","Joint person's full legal name:","Joint person's date of birth:","Is the joint person living or deceased?","START CURRENT AND PREVIOUS ADDRESS PER BRANDS","What is your last known (current address) with Abbey Life?","","","Were any of your accounts with Abbey Life held jointly with the person named above?","What is your last known (current address) with Alliance and Leicester?","","","Were any of your accounts with Alliance and Leicester held jointly with the person named above?","What is your last known (current address) with American Express?","","","Were any of your accounts with American Express held jointly with the person named above?","Have you ever held a paid packaged bank account with American Express?","Date PBA account started?","Account number of PBA:","What is your last known (current address) with Aqua Cards?","","","Were any of your accounts with Aqua Cards held jointly with the person named above?","What is your last known (current address) with Argos?","","","Were any of your accounts with Argos held jointly with the person named above?","What is your last known (current address) with Asda?","","","Were any of your accounts with Asda held jointly with the person named above?","What is your last known (current address) with Aviva Plc?","","","Were any of your accounts with Aviva held jointly with the person named above?","What is your last known (current address) with Bank of Ireland?","","","Were any of your accounts with Bank of Ireland held jointly with the person named above?","What is your last known (current address) with Bank of Scotland Motor Finance?","","","Were any of your accounts with Bank of Scotland Motor Finance held jointly with the person named above?","What is your last known (current address) with Bank of Scotland?","","","Were any of your accounts with Bank of Scotland held jointly with the person named above?","Have you ever held a paid packaged bank account with Bank of Scotland?","Date PBA account started?","Account number of PBA:","What is your last known (current address) with Barclays Bank?","","","Have you ever held a paid packaged bank account with Barclays?","Date PBA account started?","Account number of PBA:","Were any of your accounts with Barclays Bank held jointly with the person named above?","What is your last known (current address) with Barclays Partner Finance?","","","Were any of your accounts with Barclays Partner Finance held jointly with the person named above?","What is your last known (current address) with BHS?","","","Were any of your accounts with BHS held jointly with the person named above?","What is your last known (current address) with Birmingham Midshires?","","","Were any of your accounts with Birmingham Midshires held jointly with the person named above?","What is your last known (current address) with Blackhorse?","","","Were any of your accounts with Blackhorse held jointly with the person named above?","What is your last known (current address) with BMW Finance?","","","Were any of your accounts with BMW Finance held jointly with the person named above?","What is your last known (current address) with Bradford & Bingley?","","","Were any of your accounts with Bradford and Bingley held jointly with the person named above?","What is your last known (current address) with Bristol and West Mortgages?","","","Were any of your accounts with Bristol and West Mortgages held jointly with the person named above?","What is your last known (current address) with Bristol Street Motors?","","","Were any of your accounts with Bristol Street Motors held jointly with the person named above?","What is your last known (current address) with Britannia?","","","Were any of your accounts with Britannia held jointly with the person named above?","What is your last known (current address) with Capital Bank HBOS Finance?","","","Were any of your accounts with Capital Bank HBOS held jointly with the person named above?","What is your last known (current address) with Capital One?","","","Were any of your accounts with Capital One held jointly with the person named above?","What is your last known (current address) with Car Giant?","","","Were any of your accounts with Car Giant held jointly with the person named above?","What is your last known (current address) with Cardif Pinnacle?","","","Were any of your accounts with Cardif Pinnacle held jointly with the person named above?","What is your last known (current address) with Carlyle Finance?","","","Were any of your accounts with Carlyle Finance held jointly with the person named above?","What is your last known (current address) with Cheltenham and Gloucester?","","","Were any of your accounts with Cheltenham and Gloucester held jointly with the person named above?","What is your last known (current address) with Chelsea Building Society?","","","Were any of your accounts with Chelsea Building Society held jointly with the person named above?","What is your last known (current address) with Cheshire Building Society?","","","Were any of your accounts with Cheshire Building Society held jointly with the person named above?","What is your last known (current address) with Citi Financial Europe PLC?","","","Were any of your accounts with Citi Financial Europe PLC held jointly with the person named above?","What is your last known (current address) with Close Brothers Premium Finance?","","","Were any of your accounts with Close Brothers Premium Finance held jointly with the person named above?","What is your last known (current address) with Close Motor Finance?","","","Were any of your accounts with Close Motor Finance held jointly with the person named above?","What is your last known (current address) with Clydesdale Bank Asset Finance Limited?","","","Were any of your accounts with Clydesdale Bank Asset Finance Limited held jointly with the person named above?","What is your last known (current address) with Co-Operative?","","","Were any of your accounts with Co-Operative held jointly with the person named above?","What is your last known (current address) with Comet?","","","Were any of your accounts with Comet held jointly with the person named above?","What is your last known (current address) with Commerical First?","","","Were any of your accounts with Commerical First held jointly with the person named above?","What is your last known (current address) with Coventry Building Society?","","","Were any of your accounts with Coventry Building Society held jointly with the person named above?","What is your last known (current address) with Creation Consumer Finance Ltd?","","","Were any of your accounts with Creation Consumer Finance Ltd held jointly with the person named above?","What is your last known (current address) with Currys?","","","Were any of your accounts with Currys held jointly with the person named above?","What is your last known (current address) with Debenhams Finances?","","","Were any of your accounts with Debenhams Finances held jointly with the person named above?","What is your last known (current address) with DFS?","","","Were any of your accounts with DFS held jointly with the person named above?","What is your last known (current address) with Dixions Retail PLC?","","","Were any of your accounts with Dixions Retail PLC held jointly with the person named above?","What is your last known (current address) with Egg Card?","","","Were any of your accounts with Egg Card held jointly with the person named above?","What is your last known (current address) with First Assist?","","","Were any of your accounts with First Assit held jointly with the person named above?","What is your last known (current address) with GE Money Servicing Limited Resolutions?","","","Were any of your accounts with GE Money Servicing Limited Resolutions held jointly with the person named above?","What is your last known (current address) with GMAC Financial Services?","","","Were any of your accounts with GMAC Financial Services held jointly with the person named above?","What is your last known (current address) with Halifax?","","","Have you ever held a paid packaged bank account with Halifax?","Date PBA account started?","Account number of PBA:","Were any of your accounts with Halifax held jointly with the person named above?","What is your last known (current address) with HFC Bank?","","","Were any of your accounts with HFC Bank held jointly with the person named above?","What is your last known (current address) with HSBC?","","","Have you ever held a paid packaged bank account with HSBC?","Date PBA account started?","Account number of PBA:","Were any of your accounts with HSBC held jointly with the person named above?","What is your last known (current address) with Ikano Finance?","","","Were any of your accounts with Ikano Finance held jointly with the person named above?","What is your last known (current address) with John Lewis?","","","Were any of your accounts with John Lewis held jointly with the person named above?","What is your last known (current address) with Kensington Mortgages?","","","Were any of your accounts with Kensington Mortgages held jointly with the person named above?","What is your last known (current address) with Leeds Building Society?","","","Were any of your accounts with Leeds Building Society held jointly with the person named above?","What is your last known (current address) with Legal and General?","","","Were any of your accounts with Legal and General held jointly with the person named above?","What is your last known (current address) with Littlewoods?","","","Were any of your accounts with Littlewoods held jointly with the person named above?","What is your last known (current address) with Lloyds?","","","Have you ever held a paid packaged bank account with Lloyds?","Date PBA account started?","Account number of PBA:","Were any of your accounts with Lloyds held jointly with the person named above?","What is your last known (current address) with Lombard Direct?","","","Were any of your accounts with Lombard Direct held jointly with the person named above?","What is your last known (current address) with Marks and Spencer?","","","Have you ever held a paid packaged bank account with Marks and Spencer?","Were any of your accounts with Marks and Spencer held jointly with the person named above?","What is your last known (current address) with MBNA?","","","Were any of your accounts with MBNA with the person named above?","What is your last known (current address) with Mercedes Benz Financial Services?","","","Were any of your accounts with Mercedes Benz Financial Services held jointly with the person named above?","What is your last known (current address) with MFI Retail Limited?","","","Were any of your accounts with MFI Retail Limited held jointly with the person named above?","What is your last known (current address) with Mint Credit Card?","","","Were any of your accounts with Mint Credit Card held jointly with the person named above?","What is your last known (current address) with Monument Financial Services?","","","Were any of your accounts with Monument Financial Services held jointly with the person named above?","What is your last known (current address) with Morgan Stanley?","","","Were any of your accounts with Morgan Stanley held jointly with the person named above?","What is your last known (current address) with Mortgage Express?","","","Were any of your accounts with Mortgage Express held jointly with the person named above?","What is your last known (current address) with Nationwide Corporate Finance?","","","Were any of your accounts with Nationwide Corporate Finance held jointly with the person named above?","What is your last known (current address) with Nationwide?","","","Were any of your accounts with Nationwide held jointly with the person named above?","Have you ever held a paid packaged bank account with Nationwide?","Date PBA account started?","Account number of PBA:","What is your last known (current address) with Natwest?","","","Have you ever held a paid packaged bank account with Natwest?","Date PBA account started?","Account number of PBA:","Were any of your accounts with Natwest held jointly with the person named above?","What is your last known (current address) with Nissan Finance?","","","Were any of your accounts with Nissan Finance held jointly with the person named above?","What is your last known (current address) with Northern Rock?","","","Were any of your accounts with Northern Rock held jointly with the person named above?","What is your last known (current address) with OpenWork Limited?","","","Were any of your accounts with OpenWork Limited held jointly with the person named above?","What is your last known (current address) with Opus Card?","","","Were any of your accounts with Opus Card held jointly with the person named above?","What is your last known (current address) with Post Office Ltd?","","","Were any of your accounts with Post Office Ltd held jointly with the person named above?","What is your last known (current address) with Rooftop Mortgages?","","","Were any of your accounts with Rooftop Mortgages held jointly with the person named above?","What is your last known (current address) with Royal Bank of Scotland?","","","Were any of your accounts with Royal Bank of Scotland held jointly with the person named above?","Have you ever held a paid packaged bank account with Royal Bank of Scotland?","Date PBA account started?","Account number of PBA:","What is your last known (current address) with Sainsbury's Bank?","","","Were any of your accounts with Sainsbury's Bank held jointly with the person named above?","What is your last known (current address) with Santander Consumer Finance?","","","Were any of your accounts with Santander Consumer Finance held jointly with the person named above?","What is your last known (current address) with Santander?","","","Have you ever held a paid packaged bank account with Santander?","Date PBA account started?","Account number of PBA:","Were any of your accounts with Santander held jointly with the person named above?","What is your last known (current address) with Secure Trust Bank Plc?","","","Were any of your accounts with Secure Trust Bank Plc held jointly with the person named above?","What is your last known (current address) with Scottish Provident?","","","Were any of your accounts with Scottish Provident held jointly with the person named above?","What is your last known (current address) with Scottish Widows?","","","Were any of your accounts with Scottish Widows held jointly with the person named above?","What is your last known (current address) with Shawbrook Bank Limited?","","","Were any of your accounts with Shawbrook Bank Limited held jointly with the person named above?","What is your last known (current address) with Standard Chartered PLC?","","","Were any of your accounts with Standard Chartered PLC held jointly with the person named above?","What is your last known (current address) with Standard Life?","","","Were any of your accounts with Standard Life held jointly with the person named above?","What is your last known (current address) with Tesco Bank?","","","Were any of your accounts with Tesco Bank held jointly with the person named above?","What is your last known (current address) with The Mortgage Works?","","","Were any of your accounts with The Mortgage Works held jointly with the person named above?","What is your last known (current address) with TSB?","","","Were any of your accounts with TSB held jointly with the person named above?","Have you ever held a paid packaged bank account with TSB?","Date PBA account started?","Account number of PBA:","What is your last known (current address) with UCB Home Loans?","","","Were any of your accounts with UCB Home Loans held jointly with the person named above?","What is your last known (current address) with Ulster Bank?","","","Were any of your accounts with Ulster Bank held jointly with the person named above?","Have you ever held a paid packaged bank account with Ulster Bank?","Date PBA account started?","Account number of PBA:","What is your last known (current address) with Vanquis?","","","Were any of your accounts with Vanquis held jointly with the person named above?","What is your last known (current address) with Virgin Money?","","","Were any of your accounts with Virgin Money held jointly with the person named above?","What is your last known (current address) with Woolwich?","","","Were any of your accounts with Woolwich held jointly with the person named above?","What is your last known (current address) with Yorkshire Bank?","","","Were any of your accounts with Yorkshire Bank held jointly with the person named above?","Have you ever held a paid packaged bank account with Yorkshire Bank/Clydesdale Bank?","Date PBA account started?","Account number of PBA:","What is your last known (current address) with Yorkshire Building Society?","","","Were any of your accounts with Yorkshire Building Society held jointly with the person named above?","What is your last known (current address) with Zurich Assurance Ltd?","","","Were any of your accounts with Zurich held jointly with the person named above?","If there are any other UK based financial institution(s) or insurance company(s) not mentioned above which apply to you please state them here along with the name of the Products that you have used with them: (We will also investigate those firms fo)","Which of the above have you held as a Business Account? please state and inform. Did you also hold personal accounts at the same firm(s)?","Any other comment/information you want to provide?","Only select those which apply:","Have you previously claimed before?","Upload Identification (Driving licence or passport)","Upload Evidence of accounts","Referrer name",""
"","Ali","","Demirtas","","","d@hotmail.com","01/01/1000 ","Alliance and Leicester","Flat 309 JT residential address","Yes","Gizem GT TASAN","11/11/1111 ","Living and you are in contact with","","","","","","The address where you are currently 'residing' (address you provided as above)","","","Yes, account was jointly held","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""
That's everything including the bottom, I don't want to recreate the variable name if they already exist this would lead to duplication issues.
The user has a choice of 100 Brands, for each brand selected by the user I need to generate a PDF from this data, preferably using scripting and not opening the PDF. Email all PDFs together and print them too if possible (single sided in colour).
Desired outcome to achieve:
- Lead completes form which results in the email to us [Done]
- We then extract the information from email (extract information using the questions as the variable names)
- Generate PDFs from information in email (1 PDF per Brand/Bank selected, preferably without having to open the PDF using scripting)
- Email the PDFs all together back to the user (email provided by them in the form) and to our mailbox as CC (preferably the PDFs should be editable once emailed in case they need to be amended)
- PDFs are also sent to the printer to print
Thanks a lot guys.
I have hit a wall and cannot do this part (I'm willing to pay to get this done if it helps)