I’ve resolved this any number of times in my clinic including some very bad cases you had even tried nerve blocks previously. It is treatable.
That said, herbs are not generally, in my opinion, the most useful for this in many cases. Whereas proper acupuncture will lead to much better results. Certainly trying out different herbs and formulas based on symptoms isn’t going to work at all - they require proper diagnosis of the underlying causes (see “treating the cause and not the symptoms”).
While bu zhong yi qi wan can be used for “spontaneous” or “easy” sweating - it is technically for spleen qi deficiency. So if you are perfect fit for that pattern, then it might be helpful. In most cases hyperhidrosis has at least some aspect of yin deficiency particularly in a 43 yo female, so, again, proper diagnosis is key. If it has been an issue for a long time, by now your situation will generally be quite layered so a practitioner will have to tailor treatment over time - generally this would take 2-6 months to resolve or at least heavily limit the responses.