Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Question about Mailmerge Directory
I have an excel sheet that I'm printing a directory from. There are 4
fields at the end of the sheet that I would like printed out when the mailmerge takes place. However, what happens is that the mailmerge hangs up my computer for some reason. The data structure is name & address info, with the final 4 fields being things like Family, Career, Awards and Remembrances. In some cases, some of the fields would be submitted, some would not. For instance, Person #1 may have nothing in those 4 fields, Person #2 may have something in the last field. Person #3 would have something in Fields 1, 2 and 4. Person # 4 would have something in all 4 fields. The way it will "work" in the mailmerge is if I just have the fields displayed in a list, like below: Name Address * Family * Career * Awards * Remembrances What I want is to display a literal that is beside that field, if it is there. If person #2 has something in remembrances I'd like for it to be: Person 2 Person2 Address * Remembrances: some text about remembrances, etc. where the literal "Remembrances:" is displayed there. I don't want family, career and other displayed if the fields are blank. Person #3 would be like: Person 3 Person3 address * Family: list family info * Career: list career info * Remembrances: list remembrances. I've gone & edited the field and tried to put a literal there that would display before the field, but the mailmerge hangs up on me, I am guessing that it is doing it when there's nothing in that field. Is there a way to do this to make it work so that if someone has filled in only partial fields that the appropriate literal will display for that entry? Also, why is Mailmerge hanging up with me when I try to do this? Thanks BC |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hi...Two Question Concerning Envelopes via MailMerge... | Mailmerge | |||
Another access-word mailmerge question | Mailmerge | |||
Another mailmerge from Excel question | Mailmerge | |||
Question for the WordXP mailmerge - masta's | Mailmerge | |||
Outlook -> Word Mailmerge defaults question - Zipcode missing from Addressblock | Mailmerge |