Hello Everyone,



I have a document with many drop down menus. What I am trying to do is have an email address appear in multiple spots on the document depending on what is selected out of the first drop down menu. (Incident catergory, top left hand corner)

If Safety is selected I would like EPS.safety@Huskyenergy.com to show up on all email spots

If Environmental is selected I would like EPS.spills@Huskyenergy.com to show up in all email spots

If ground disturbance is selected I would like Ground.Disturbance@Huskyenergy.com to show up in all email spots.

I am having some major problems with this. I have attached the document with arrows indicating all places where I would like the email address to populate automatically. Currently they all say eps.safety@huskyenergy.com. This was just how the document was created. These do not go in automatically.

If possible I would like to avoid the use of Macro's but at this point I don't really care how it gets done.

Thanks in advance for your assistance.

Attached Files

Test Report.docx (59.8 KB, 22 views)