Hey everyone! I'm really struggling with a problem at work involving our HR system. There's an HR employee who manages the employee database using both a Mac and a Windows PC because she needs the flexibility to move around. The database is run through a Word mail merge using an Excel file stored on OneDrive. The issue arises when she switches devices: Word loses the link to the data source, and she has to reattach it manually every time. I'm hoping to find a way to solve this and avoid the hassle when switching computers. Any suggestions?
5 Answers
Honestly, using Excel and Word for an HR system seems pretty outdated. You might want to explore better solutions tailored for HR management instead of patching this one together. It’s more efficient in the long run!
Have you considered automating this process? Tools like Power Automate or the Graph API might help streamline the data source connection, eliminating some of that manual work!
You might want to double-check how the path to the Excel file is set up. There could be syncing issues with OneDrive, too, as it might not be syncing as quickly as you need it to. Simplifying or changing the setup could help. Good luck with it!
This setup sounds like it’s intentionally difficult. Did someone set it up just to mess with the HR person? It's not a great way to manage things!
I think the trouble could stem from how Mac and Windows handle file paths differently. If it’s pulling from a local path, that’s a big problem. Maybe try using Word’s web interface for mail merges; that could be more consistent across both devices.
Related Questions
Can't Load PhpMyadmin On After Server Update
Redirect www to non-www in Apache Conf
How To Check If Your SSL Cert Is SHA 1
Windows TrackPad Gestures