Our current system of sending a letter to our client is – we type the letter on the letterhead and then check our register to add the next in line serial number to the letter as a reference.
The problem now with our employees scattered is, keeping track of that sequence. So as an alternate what we have done is that we have created an excel sheet and are maintaining it like our register. The problem we recently faced was, some of the members did not update the excel sheet and the list had double numbers.
To avoid this, I am looking for a solution where I can store the letter as well as assign the reference number also. The best part would be that the reference number gets added in the letter file at a specific location which is common and can be formatted in the template of the word.
What I tried is - I created a form, and asked users to upload the word file, and in power automate I am hoping to generate a letter reference number. But cannot do so. Can somebody guide? Also will be grateful if the sequence can be added in the word file.
Thank you in Advance.

Report
All responses (
Answers (