View Single Post
  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
emc emc is offline
external usenet poster
 
Posts: 9
Default I want to omit a field in a mail merge

Graham,

Sorry - my head is full of mince today!

I'm afraid I'm not too clued up on mail merges and don't know what a
conditional field is. Can you please elaborate on this for me? My data
source is coming from Access in case that is a problem.

EMC

"Graham Mayor" wrote:

I said don't used the AddressBlock! Remove the addressblock field from the
document and use instead the individual fields that make up the address

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


emc wrote:
Graham,

I have tried it with the AddressBlock. Unfortunately I have a number
of fields and cannot match them in the Required Information Match
Fields dialagoe box resulting in a lot of my information being
omitted. I have tried matching them in the Optional Information but
this does not appear.

Unfortunately I cannot insert the fields after the AddressBlock as
these fields are required after the LastName and before Address1.

EMC

"Graham Mayor" wrote:

For any of your question to be relevant you must be using the
AddressBlock field. Don't! Insert the individual fields as you
require them. You can then use a conditional field to insert the
FirstName field when a condition applies eg
{IF{Mergefield FirstName} "Fred" "{Mergefield FirstName}"}

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


emc wrote:
I have a mail merge with Prefix, FirstName, Surname, etc.

For various reasons when sending out mail some people should only
have their Prefix and Surname shown. I need to have their FirstName
in the merge as I use it for a large amount of other documents
otherwise I would remove it.

I have tried the "If...Then...Else" but it doesn't work and I can't
use the Skip button as this is for the entire record. Is there
another way of doing it?

Thank you.