Prev: can you capture info from a cell without retyping in another cell
Next: printing page range in word
From: Lenox on 12 Mar 2010 10:16 I know this has probably been covered but I can't find it so thanks in advance for the help. I would like to add a spouse in a mail merge. Example: <<firstname>> and <<spouse>> <<lastname>> But if the spouse doesn't exist I need to know how to eliminate the "and" and extra spaces. Thanks -Lenox
From: Suzanne S. Barnhill on 12 Mar 2010 11:28 You need this syntax: { MERGEFIELD firstname }{ IF { MERGEFIELD spouse } = "" "" " and { MERGEFIELD spouse }" } All fields must be inserted either using Insert | Field (or the button on the Mail Merge toolbar) or by pressing Ctrl+F9 to insert the field delimiters (the things that look like braces but can't be entered from the keyboard) and then typing between them. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Lenox" <Lenox(a)discussions.microsoft.com> wrote in message news:7E781A5B-0B90-4152-B1CF-C67F56C7F410(a)microsoft.com... >I know this has probably been covered but I can't find it so thanks in > advance for the help. > > I would like to add a spouse in a mail merge. Example: > <<firstname>> and <<spouse>> <<lastname>> > But if the spouse doesn't exist I need to know how to eliminate the "and" > and extra spaces. > > Thanks -Lenox >
|
Pages: 1 Prev: can you capture info from a cell without retyping in another cell Next: printing page range in word |