View Single Post
 
Old 09-25-2015, 04:30 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Try:
{If{REF Dropdown2}= "Donald Duck" "Donald.Duck{If{REF Dropdown1}= "Company B" "@companyb.com"}"}{If{REF Dropdown2}= "Mickey Mouse" {If{REF Dropdown1}= "Company B" "Mickey_Mouse@companyb.com" "Mickey.Mouse"}}{If{REF Dropdown2}= "Minnie Mouse" {If{REF Dropdown1}= "Company B" "Minnie_Mouse@companyb.com" "Minnie.Mouse"}}{If{REF Dropdown1}= "Company A" "@companya.ca" {If{REF Dropdown1}= "Company C" "@companyc.ca"}}

Note: This has nothing to do with macros - it concerns only field coding.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote