Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-09-2017, 08:02 PM
LandyVlad's Avatar
LandyVlad LandyVlad is offline Creating a template which inserts name and appropriate gender language Windows 10 Creating a template which inserts name and appropriate gender language Office 2013
Novice
Creating a template which inserts name and appropriate gender language
 
Join Date: Nov 2017
Location: Brisbane, Australia
Posts: 7
LandyVlad is on a distinguished road
Default Creating a template which inserts name and appropriate gender language

I'd like to create a document template (or rather modify an existing template) where, when opened it asks for the relevant sex (M/F) and a surname then auto-populates the various paragraphs with the words she/he, her/his etc throughout the document.

This is in the interests of ensuring consistency so as not to have reports about a male referring to she and so on.

I am NOT trying to autocorrect / find & replace existing words in the document.
I am NOT trying to do this universally / for all examples of a gendered word.

It would be for specific words and sentences only. eg

"Ms Doe submitted her application"



When I open the template it asks
Sex: M/F
Surname: ____

And then throughout the document I would have fields in the relevant places eg:

"field1 field2 submitted field3 application"

the possibilities for field1 would be "Mr" or "Ms"
field 2 is obviously just a string
the possibilities for field3 would be "his" or "her"
and so on.


The reason for doing it this way is that a portion of the document will record a record of interview and that needs to be literally as stated so no change or assumptions regarding gender.

I understand this might take some manual setting up. for the document itself, but I can live with that.

I don't know what mechanism would be the best way to accomplish this. But I'm sure someone does. I have no experience with writing macros or using buttons etc but am willing to learn.

I very much appreciate all input / advice / assistance / relevant links and so on.

Thank You
Reply With Quote
  #2  
Old 11-09-2017, 08:36 PM
macropod's Avatar
macropod macropod is offline Creating a template which inserts name and appropriate gender language Windows 7 64bit Creating a template which inserts name and appropriate gender language Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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

Not going to happen. In something like an interview record, Word has no way of detecting what gender is applicable in a given context; only a human reader can do that and, quite often, it's only the gendered pronouns, etc. that tell the reader what the speaker/writer meant.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 11-09-2017, 08:51 PM
LandyVlad's Avatar
LandyVlad LandyVlad is offline Creating a template which inserts name and appropriate gender language Windows 10 Creating a template which inserts name and appropriate gender language Office 2013
Novice
Creating a template which inserts name and appropriate gender language
 
Join Date: Nov 2017
Location: Brisbane, Australia
Posts: 7
LandyVlad is on a distinguished road
Default

I've obviously not made myself clear.
I don't want to do any manipulation of the interview portion of the document (which is only a series of numbered paragraphs).

I want to put specific fields in specific sentences - sentences which appear in EVERY document - so that the relevant word is put there.

So for example every document contains this paragraph:

Quote:
Ms surname's criminal history indicates that there are questions about her suitability to be engaged as a contractor providing services to the department. Specifically Ms surname’s criminal history raises concerns about her personal judgment, reliability, trustworthiness, maturity and honesty as well as her willingness to comply with rules and regulations.
Precisely the same paragraph could appear but in the appropriately male gender words. eg:

Quote:
Mr surname's criminal history indicates that there are questions about his suitability to be engaged as a contractor providing services to the department. Specifically Mr surname’s criminal history raises concerns about his personal judgment, reliability, trustworthiness, maturity and honesty as well as his willingness to comply with rules and regulations.
To clarify another point I believe the existing document is exactly that - a word document (.doc or .docx) titled 'report template', and not an

Last edited by LandyVlad; 11-09-2017 at 08:58 PM. Reason: clarity
Reply With Quote
  #4  
Old 11-09-2017, 09:03 PM
macropod's Avatar
macropod macropod is offline Creating a template which inserts name and appropriate gender language Windows 7 64bit Creating a template which inserts name and appropriate gender language Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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

For that, you could use a single dropdown formfield to choose the appropriate gendered honorific, combined with formula fields & cross-references for the gendered output, coupled with a formfield & cross-references for the surname. Simply ensure the formfields have their 'calculate on exit' property set and apply 'filling in forms' protection to the Section containing the relevant content. See attached.
Attached Files
File Type: docx FormDemo.docx (26.2 KB, 38 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 11-09-2017, 09:53 PM
LandyVlad's Avatar
LandyVlad LandyVlad is offline Creating a template which inserts name and appropriate gender language Windows 10 Creating a template which inserts name and appropriate gender language Office 2013
Novice
Creating a template which inserts name and appropriate gender language
 
Join Date: Nov 2017
Location: Brisbane, Australia
Posts: 7
LandyVlad is on a distinguished road
Default

Thanks macro - that's a start.

Where is the code for that in the document?


I don't expect you to talk me through it, but if you could point me to the right places to learn about these mysteries, I'd appreciate it.
formfield
cross-references

Reply With Quote
  #6  
Old 11-09-2017, 10:06 PM
macropod's Avatar
macropod macropod is offline Creating a template which inserts name and appropriate gender language Windows 7 64bit Creating a template which inserts name and appropriate gender language Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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

As indicated in my previous reply, it's all done with formfields, cross-references and formula fields. Unprotecting the document and pressing Alt-F9 to toggle the field code display will display the field coding. Formfields are inserted via Developer|Constrols>Legacy Controls>Formfields. Cross-references are inserted via Insert|Cross-reference. Formula fields can be created via Ctrl-F9, then applying the appropriate syntax - including embedding cross-references where applicable.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #7  
Old 11-10-2017, 07:01 AM
Charles Kenyon Charles Kenyon is offline Creating a template which inserts name and appropriate gender language Windows 10 Creating a template which inserts name and appropriate gender language Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,124
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

See the Gender Toolbar Add-In. It should do what you want.
It uses a document property for gender which can be set using a button on the ribbon. Alternative gender-specific words can be inserted from the menu.

The terms are IF Fields that test for the gender property. If gender is changed using the button, the fields are updated. These fields are stored as AutoText in the template.

The Add-In is not needed to use the document/template produced although it makes it easier to change gender. If the Add-In is used to produce the template, the user (without the Add-In) can change the gender of the terms by changing the custom document property gender and then updating the fields. You could build something into your template (in an AutoNew macro, perhaps) to query about the gender and then update the fields in the new document.



The download includes a pdf of the Add-In (won't function as an Add-In), a .dot version for menu versions of word and the Add-In.

Last edited by Charles Kenyon; 11-10-2017 at 09:19 AM.
Reply With Quote
  #8  
Old 11-10-2017, 07:14 AM
Charles Kenyon Charles Kenyon is offline Creating a template which inserts name and appropriate gender language Windows 10 Creating a template which inserts name and appropriate gender language Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,124
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

I would urge you to make what you are doing an actual Word template.
Templates in Microsoft Word
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Checking Gender Sharath_MS_Forums Word VBA 19 07-08-2014 09:14 AM
Creating a template which inserts name and appropriate gender language When creating new template from established template macros getting lost. TechEd Word 3 06-09-2014 07:22 PM
PPT-Template Language Issues nunezc PowerPoint 0 04-18-2012 01:18 PM
Creating document from template but macros are still linked to template webharvest Word 0 07-16-2011 09:34 AM
Creating a template which inserts name and appropriate gender language Should have been possible to specify a template's language Malvin PowerPoint 2 07-08-2011 12:25 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:40 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft