The Import feature acts as a facilitator to quickly send direct mail to addresses. There are two methods and types of files that can be imported:


  • Excel Spreadsheet .xls and .xlsx (Such as existing address lists or HMO registers)
  • Title Deeds .PDF (From Land Registry)

Excel Spreadsheet import (.xls/.xlsx)

To import a spreadsheet, simply select the Import tab and then select Address list (*.xls, *.xlsx) as the input file and then Open. Choose your input file and then click Next.




The first 20 lines will be shown to gives you a good example of the data you are importing. The next step is to match up the data on your spreadsheet with the data fields PSEngine provides for the import Excel spreadsheets. 


The data fields available on the Import address list are:


  • Full Name
  • First Name
  • Last Name
  • Full Address
  • Address 1
  • Address 2
  • City/Area
  • Postcode


Simply go row by row and select which column contains the data you wish. This allows you to enter a spreadsheet of your own design, removing the need to translate your data into a PSEngine format Excel spreadsheet. 



Now that the data fields you wish to use are all set-up, click next in the bottom right hand corner.



 


PSEngine will now process all the selected data from the spreadsheet. Depending on the amount of data, this may take a few moments to process.



Once processed, you can select the addresses you wish to send to and click Send Mail.



The standard Send Dialogue is then seen from which you can preview, select and edit your details and information/wildcards to be sent in the mail piece.


Finally, simply select the checkboxes and click Send. A final confirmation box will appear and ask you to confirm with Yes.





Title Deeds .pdf


You can import title deeds of land or properties straight into PSEngine. This allows almost immediate sending of letters to vendors of properties and land that you have identified. 


You could

  • Purchase title deeds of land parcels using inspire ID (See Mapping) or through PSEngine, and import to send mail pieces instantly.
  • Find the owner of empty properties and import the title deed to send mail pieces instantly.
  • Find the owner details of the rental properties and import the title deed to send mail pieces instantly.


To import a Title Deed, simply select the Import tab and then select Title Deed (*pdf) as the input file,and then click open. Choose your input file and then click Next.




The owners details are then instantly extracted from the document.



Once processed, you can select the addresses you wish to send to and click Send Mail.


The standard Send Dialogue is then seen from which you can preview, select and edit your details and information/wildcards to be sent in the mail piece.


Finally, simply select the checkboxes and click Send and then confirm with Yes.