I ccreated a report to mail merge as a greeting line in Word and i cant get it quite right. can anyone help me?
i want to just pull out the first names put htem together if they have a spouse and slap it in a greeting line. like Dear Mike and Brenda, no last names. i'm able to get the data but the first name always appears twice if there is a head of household and a profile for that person. is there an expression i can use to get the second duplicate record to stop printing but still allow head of household to print when there are single people in the database?
Thanks so much!
Brenda
p.s. this seems like it should be easier than it is so i'm sure i'm doing something wrong.
Creating a text report for mail merging a letter
Moderators: Moderators, Tech Support