Learn English – How to reply to thank you from worker who takes orders in restaurant

It might be better to just say, "Thank you." and omit "in advance." I think this implies that you are grateful that they took their time to consider your request. It would probably be a good idea to thank them again afterward, this time for whatever work they did to help you.

Unfortunately, some people (many of whom are very outspoken) will be offended by almost anything.

Usually, the best practice is to use the conventions that are generally accepted among whichever group of people you are communicating with.

Another option -- depending on if you will be replying in email, in detail -- is to thank her happily for the information in the email, respond to that as appropriate, and just not mention anything about the apology one way or the other. In a face-to-face conversation, you could say, "It's all right" to an apology or some other small-talk, but making a point to address the "sorry I'm late" in an email would generally need to be done with humor or other truthful understanding about busy lives. E.g., after an ice storm, I was able to write things like, "No worries; turned out I lost Internet for three days anyway!"

(But if you do acknowledge the apology instead of just letting it pass off and indicating your no-hard-feelings by how you react in the rest of the message, another possible reply would be, "I understand; life gets busy. Thanks for getting this to me!")