Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-26-2022, 05:43 AM
john098 john098 is offline Footer with individual phone numbers Windows 8 Footer with individual phone numbers Office 2019
Novice
Footer with individual phone numbers
 
Join Date: Oct 2022
Posts: 1
john098 is on a distinguished road
Default Footer with individual phone numbers

Hi!

I want to create individual templates for my colleagues, that have the following details in the footer: page number, author, time of creation and the individual phone number of the author. Only the latter is not working by inserting field functions.



In order to have the number in the footer we used to insert the users phone number in MS user details (phone number in address field) and inserted field function USERADDRESS but this seems not to work anymore.

What am I doing wrong? Am I missing something or is there a better way to solve this?

Thanks in advance for your help
Reply With Quote
  #2  
Old 10-26-2022, 06:25 AM
Charles Kenyon Charles Kenyon is offline Footer with individual phone numbers Windows 11 Footer with individual phone numbers Office 2021
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,136
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

The way I do this is to have the information saved as AutoText or some other building block stored in a global template with a different template on each user's computer. Then, use an AutoText field (which works with any building block) to display the information in the letter template.

When a new document is created based on the template on that computer and print preview is run, these update with the information from the global template's entries. You can put such fields in any templates and it will pull the information.
Reply With Quote
  #3  
Old 10-26-2022, 11:09 AM
kilroyscarnival kilroyscarnival is offline Footer with individual phone numbers Windows 10 Footer with individual phone numbers Office 2021
Expert
 
Join Date: May 2019
Posts: 344
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default

Quote:
Originally Posted by Charles Kenyon View Post
The way I do this is to have the information saved as AutoText or some other building block stored in a global template with a different template on each user's computer. Then, use an AutoText field (which works with any building block) to display the information in the letter template.

When a new document is created based on the template on that computer and print preview is run, these update with the information from the global template's entries. You can put such fields in any templates and it will pull the information.
[/LIST]
I like this. Going to attempt to use this for something similar. Does the auto-text component on each individual's computer have to be saved as the same name? I would imagine it does.
Reply With Quote
  #4  
Old 10-26-2022, 12:20 PM
Charles Kenyon Charles Kenyon is offline Footer with individual phone numbers Windows 11 Footer with individual phone numbers Office 2021
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,136
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

Quote:
Originally Posted by kilroyscarnival View Post
I like this. Going to attempt to use this for something similar. Does the auto-text component on each individual's computer have to be saved as the same name? I would imagine it does.
Yes, it does. The idea is that the same template will have different information when used on different computers.

I once did this with several levels of globals: One for the firm with logos and main addresses, one with regional office information, one with local office information, and one with individual attorney information. The firm letterhead wanted all of that.
If you want, you can include an AutoNew macro in your templates to update all AutoText fields upon document creation. That is what I do.

You can also have it lock or unlink the field once it is updated so if the document is sent out in Word format it will not cause confusion or get error messages for AutoText not found.
Again, these snippets do not have to be in AutoText; they can be in any Building Block gallery including the custom ones. The AutoText Field still gets the info.
Reply With Quote
  #5  
Old 10-26-2022, 02:41 PM
Guessed's Avatar
Guessed Guessed is offline Footer with individual phone numbers Windows 10 Footer with individual phone numbers Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,973
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Rather than customising a secondary template for each user, in the past I've done this by using a macro to write user-specific information to their registry and then the templates read this as new documents are created.

Office addresses would be configured as entries saved as building blocks and the preferred office name/id might be stored in the registry. This would allow users to move between offices and change locations in the document and still retain a 'default' office location.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #6  
Old 10-27-2022, 04:27 AM
gmayor's Avatar
gmayor gmayor is offline Footer with individual phone numbers Windows 10 Footer with individual phone numbers Office 2019
Expert
 
Join Date: Aug 2014
Posts: 4,103
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

Another possibility, and one I tend to use myself, would be to create a lookup table of the users (see attached) which I would store in the same location as the template, to insert the required data in a content control (or controls) in the documents created from the template.
To see how this would work, put the template and workbook from the attachment in the same folder. Add your username, initials and phone number to the worksheet, then create a new document from the template.
Attached Files
File Type: zip Word Template.zip (32.8 KB, 2 views)
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Merging phone numbers with + sign WibbleWobble Mail Merge 2 12-28-2019 04:29 AM
Footer with individual phone numbers Mail Merge Formatting Phone numbers Marie_Melody Mail Merge 4 07-02-2014 04:22 PM
Footer with individual phone numbers can you change department field in phone numbers pspec Outlook 2 04-05-2014 02:51 AM
Converting Phone Numbers Question certified_techy Excel 8 06-08-2012 02:27 AM
Create Custom Labels for Phone numbers Tonistep Outlook 0 03-26-2012 02:57 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:43 AM.


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