The most likely cause for the spotting is trauma to the vaginal wall as the surfaces become drier during and after menopause
making penetration traumatic. You could make it easier by application of lubricants during the process. Yet, it would be better if you have your consultant have a look for proper opinion and to exclude any other cause. Please take adequate fluids and healthy diet. Hope your query has been answered. Wish you good health.