Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Blasting Cap
 
Posts: n/a
Default 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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Hi...Two Question Concerning Envelopes via MailMerge... Infoman Mailmerge 2 August 28th 05 09:19 PM
Another access-word mailmerge question Mike Mailmerge 4 July 19th 05 12:41 PM
Another mailmerge from Excel question Paul - NottsUK Mailmerge 2 May 18th 05 10:19 AM
Question for the WordXP mailmerge - masta's Jürgen Germonpré Mailmerge 1 March 4th 05 01:12 PM
Outlook -> Word Mailmerge defaults question - Zipcode missing from Addressblock Michael Krause Mailmerge 3 December 4th 04 12:24 AM


All times are GMT +1. The time now is 07:59 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"