Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-28-2013, 12:11 AM
dfwman dfwman is offline Need Help w/Mail Merge - Multiple Lots & 1 Owner - Don't want to send Duplicates Mac OS X Need Help w/Mail Merge - Multiple Lots & 1 Owner - Don't want to send Duplicates Office for Mac 2011
Novice
Need Help w/Mail Merge - Multiple Lots & 1 Owner - Don't want to send Duplicates
 
Join Date: Mar 2013
Posts: 2
dfwman is on a distinguished road
Default

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
File Type: xlsx Crescent Oak Vacant Lots.xlsx (86.8 KB, 10 views)
File Type: docx Crescent Oak Vacant Lots.docx (47.4 KB, 9 views)
Reply With Quote
  #2  
Old 03-28-2013, 02:52 AM
macropod's Avatar
macropod macropod is offline Need Help w/Mail Merge - Multiple Lots & 1 Owner - Don't want to send Duplicates Windows 7 64bit Need Help w/Mail Merge - Multiple Lots & 1 Owner - Don't want to send Duplicates Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,927
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Your 'form letter' isn't set up anything like what the tutorial describes. For some worked examples, see the attachments to the posts at:
https://www.msofficeforums.com/mail-...html#post23345
https://www.msofficeforums.com/mail-...html#post30327
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 03-28-2013, 04:20 PM
dfwman dfwman is offline Need Help w/Mail Merge - Multiple Lots & 1 Owner - Don't want to send Duplicates Mac OS X Need Help w/Mail Merge - Multiple Lots & 1 Owner - Don't want to send Duplicates Office for Mac 2011
Novice
Need Help w/Mail Merge - Multiple Lots & 1 Owner - Don't want to send Duplicates
 
Join Date: Mar 2013
Posts: 2
dfwman is on a distinguished road
Default

I have altered the merge document based on the examples, but I am really having an incredibly frustrating time still. Why is my text body not showing up?
Attached Files
File Type: docx Crescent Oak Vacant Lots.docx (39.4 KB, 13 views)
Reply With Quote
  #4  
Old 03-28-2013, 07:11 PM
macropod's Avatar
macropod macropod is offline Need Help w/Mail Merge - Multiple Lots & 1 Owner - Don't want to send Duplicates Windows 7 64bit Need Help w/Mail Merge - Multiple Lots & 1 Owner - Don't want to send Duplicates Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,927
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Try the attached. Your field coding had some problems, including that you'd left in some unused fields from one of the links, and your use of the fields for the Key creation & testing were inconsistent - I've changed the two occurrences of:
{QUOTE{ MERGEFIELD Owner_First_Name }{ MERGEFIELD Owner_Last_Name}} (with their inconsistent switch usage)
to:
{MERGEFIELD Mail_Owner_Name}
You also need to add a new last row with a 0 in the 'Mail Owner Name' column in your workbook, so that the last record will be output.

As for why your body text isn't showing up, that suggests you're merely previewing the merge instead of executing it - via the Finish & Merge button.
Attached Files
File Type: docx Crescent Oak Vacant Lots.docx (20.7 KB, 15 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Send e-mail message in Finish & Merge CDTom Mail Merge 1 08-24-2012 12:52 AM
Need Help w/Mail Merge - Multiple Lots & 1 Owner - Don't want to send Duplicates Mail Merge multiple rows? ender541 Mail Merge 1 08-21-2012 03:14 PM
Need Help w/Mail Merge - Multiple Lots & 1 Owner - Don't want to send Duplicates Multiple Mail Merge? imogul Mail Merge 1 06-24-2011 07:20 PM
Need Help w/Mail Merge - Multiple Lots & 1 Owner - Don't want to send Duplicates Send fax with mail merge image (logo) problem dipak.patel@i-link.co.in Mail Merge 1 01-06-2011 10:10 AM
Need Help w/Mail Merge - Multiple Lots & 1 Owner - Don't want to send Duplicates Send/Receive Duplicates All Email javauno Outlook 2 07-17-2009 07:16 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:21 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2023, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2023 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft