I want to mail some real estate property owners, and some of the owners own multiple properties/lots. I don't want to send out a lot of duplicate letters. I have read through the tutorial docs that macropod did, but after 2 hours of trying to figure this out, I am asking for help. I usually don't have any trouble solving technical issues like this but I am begging for help!!!



I have attached my word file and the data file.

My "key" field is the "mail owner name". If the owner has only 1 property, I want the sentences to read a "vacant lot", and if they own more I want it to read "vacant lots".

The salutation will be the first and last name fields, which is different from the key field.

The lot addresses will then be displayed in the letter, starting with the Standardized House Number then Street.

I have set this up as a catalog, but is this correct even though I am doing a form letter?

Please help!!

Joe

Not sure if this is important or not, but I am using Word for Mac 2011.

Attached Files

	Crescent Oak Vacant Lots.xlsx (86.8 KB, 10 views)
	Crescent Oak Vacant Lots.docx (47.4 KB, 9 views)