07-01-2013 10:06 PM - edited 07-01-2013 11:02 PM
I am currently in the process of doing a large mail merge to our clients on their current property values, I have so far managed to design the letter in order that it pre-populates their name, address etc. however i am having bother pre-populating the values below into my letter.
Can someone please help me with the what needs to be inserted in order to merge each of the fields?
I am on a shared networmk using Windows 7 and Microsoft Office 2010.
Thanks in advance.
07-02-2013 01:39 AM
If you edit the template are the fields not avaialble to select. In Word click on the Add-ins tab at the top then ACT! on the drop down list click on 'show field list' all the fields that are in your database shouls appear in this list.
07-02-2013 07:16 AM
The field you're trying to report on reside in the ACT! opportunity table. Unfortunately it is not possible to mailmerge fields from this table. In order to do a mailmerge, the fields must reside in the contacts table.
07-02-2013 07:20 AM
My suggestion for designing your database would be to create one contact record per property. You then need to customize the contact table with the property related fields you're trying to create. Then he would be able to use the mailmerge feature. We've created a large mortgage specific ACT! database using this methodology. In this case each loan or property purchase becomes an ACT! contact record.
Here is a link to a bunch of screenshots that we did for the mortgage database. It might be useful for you in terms of ideas on how to design your database.