IPAddr

Mail Merge using Microsoft Word from Rent Master or Ausbroker

If you want to send letters to every Landlord, every Tenant or every Creditor in Rent Master or every Vendor, every Purchaser, every Bank, every Council, every Land Agent etc in Ausbroker you could setup normal letters in Rent Master or Ausbroker and use Rent Master or Ausbroker to generate the letters.

HOWEVER

It may be easier to export the name and address information into Microsoft Excel and once you have it in Excel then you can do a normal mail merge using Microsoft Word. If you paste one of the SQL execute scripts shown below into the SQL EXECUTE function in Rent Master or Ausbroker it will generate a list of names and addresses for you. You can then export this list and open it in Microsoft Excel. You can then manipulate the list to only have the names in it that you want to send a letter to. Then save it as an XLS file and use the mail merge function in Microsoft Word to link to this file and merge the letters.

Below are queries for landlords, creditors and tenants from Rent Master and Agents, Banks, Vendors, Purchasers, Local councils, otrher Conveyancers etc from Ausbroker.


Rent Master Landlord Name and Address List
Select [Landlord Code] as [Code], [Name],
[Address 1], [Address 2], [Suburb], [Postcode],
[Salutation], [Department],
[Email Address], [Work Phone], [Home Phone], [Fax Number], [Mobile Phone]
From [Landlord]
Where [Active]
Order By [Department], [Landlord Code]
Rent Master Creditor Name and Address List
Select [Creditor Code] as [Code], [Name],
[Address 1], [Address 2], [Suburb], [Postcode],
[Salutation],
[Email Address], [Work Phone], [Home Phone], [Fax Number], [Mobile Phone]
From [Creditor]
Where [Active]
Order By [Creditor Code]
Rent Master Tenant Name and Address List
Select [Property Code] & "/" & [Tenant Code] as [Code], [Name],
[Address 1], [Address 2], [Suburb], [Postcode],
[Salutation],
[Email Address], [Work Phone], [Home Phone], [Fax Number], [Mobile Phone]
From [Tenant]
Where [Active]
Order By [Property Code], [Tenant Code]
Ausbroker Land Agent Name and Address List
Select [Code], [Name], [Contact Name],
[Address 1], [Address 2], [Suburb], [Postcode],
[Email Address], [Phone Number], [Fax Number], [Home Phone Number], [Mobile Phone Number]
From [Land Agents]
Order By [Code]
Ausbroker Other Conveyancers Name and Address List
Select [Code], [Name], [Contact Name],
[Address 1], [Address 2], [Suburb], [Postcode],
[Email Address], [Phone Number], [Fax Number], [Home Phone Number], [Mobile Phone Number]
From [Other Brokers]
Order By [Code]
Ausbroker Local Councils Name and Address List
Select [Code], [Name], [Contact Name],
[Address 1], [Address 2], [Suburb], [Postcode],
[Email Address], [Phone Number], [Fax Number], [Home Phone Number], [Mobile Phone Number]
From [Local Councils]
Order By [Code]
Ausbroker Banks Name and Address List
Select [Bsb Number], [Bank Short Name], [Bank Branch Name], [Contact Name],
[Address 1], [Address 2], [Suburb], [Postcode], [Fax Number],
[Mobile Phone Number], [Email Address], [Dx Number]
From [Banks]
Order By [Bsb Number]
Ausbroker Vendors Name and Address List
Select [Client Code] & "/" & [Sequence] as [Code], [Name], [Salutation], [Short Name],
[Address 1], [Address 2], [Suburb], [Postcode],
[New Address 1], [New Address 2], [New Suburb], [New Postcode],
[Phone Number], [Mobile Phone Number], [Home Phone Number], [Fax Number],
[Email Address], [New Home Phone Number], [Date Moved]
From [Vendors]
Order By [Client Code], [Sequence]
Ausbroker Purchasers Name and Address List
Select [Client Code] & "/" & [Sequence] as [Code], [Name], [Salutation], [Short Name],
[Address 1], [Address 2], [Suburb], [Postcode],
[New Address 1], [New Address 2], [New Suburb], [New Postcode],
[Phone Number], [Mobile Phone Number], [Home Phone Number], [Fax Number],
[Email Address], [New Home Phone Number], [Date Moved]
From [Purchasers]
Order By [Client Code], [Sequence]

How to Use SQL Execute

Structured Query Language (or SQL) is the programming language of most databases. You can use SQL to generate and display the results of a database query (which is just reporting on the data in the database) OR you can use SQL to actually modify the data in the database.
To use a SQL statement that we have emailed to you then you need to do the following...
  1. Use your mouse to highlight the SQL command we have sent you in this email
  2. Select COPY from the EDIT menu at the top of the form.
  3. Go into your Rent Master, Payroll or Ausbroker program (Or whatever program you purchased from us).
  4. Click on the SQL EXECUTE STATEMENTS option from the DATABASE menu.
  5. Enter a Description for this query (so you remember what the Query is for) and click on the EDIT button
  6. Click on the PASTE option from the EDIT menu in the Edit form.
  7. Click on the SAVE button to save the query
  8. Click on the DO IT button to execute the query
  9. If the query returns data for you to view then you can click on the EXPORT button to export the data into Microsoft Excel.
If the query returns data for you to view then the results of the query will be displayed for you. If the query modifies data in your database then it should just print a message saying STATEMENT COMPLETED. If it displays an error message or no message then the query probably didn't work. Any SQL command that you processed using this method has been saved using the name that you entered earlier. If the SQL command was a database query displaying a report then you can also generate the report again by clicking on the report name in the USER SQL QUERY option from the Inquiry menu.