Allow mail merge with source files stored on OneDrive
Please support mail merge with source files stored on OneDrive.
I was dumbfounded when I discovered this issue. Using Publisher Mailmerge I could not get it to interact with an Excel list sitting on OneDrive. The spreadsheet was visible. But when I tried to connect, I got the typical MS gibberish that means something to someone somewhere, but means nothing to a normal computer user. So I had to guess. Hmm. It looks like Mailmerge to this file doesn’t work I wonder why! Maybe if I save the database to the desktop then it will work. Hurray! It worked. Now I have two copies of the same spreadsheet, I wonder which one Im working now when I go back to add data. And do you think Microsoft added an explanation that would pop up and explain why Mailmerge doesn’t work with a onedrive database? Heck no! It’s obvious to them they need no explanation and it doesn’t even occur to these nerd geeks that a normal person would need some guidance here. don’t know which problem I hate worse. The inability to Mailmerge to a onedrive database. Or the inability of Microsoft to communicate with an average user. I guess it would be the latter problem because it has gone on at MS for more than thirty years. It has been the source of endless exasperation as I had to figure things out by myself. It smacks of myopic arrogant ignorance. MS do some market research and find out where users are getting confused, tied up and ultimately walking away.
For me was a big surprise to not being able to do this, we have some databases that everyone is using and editing at the same time in my company, obviously the file is not "local" so I can't use this function.
Indeed a complete mockery of OneDrive, and vote is closed, i.e. MS is not interested solving it.
Not being able to used shared data store for mail merge functions makes a complete mockery of having shared data storage. This functionality needs to consider two aspects of OneDrive storage - (a) A user's own contents (b) Another user's content shared with the user wanting to do mail merge. Facility needs to be able to have data source and mail merge document (word & Publisher) in OneDirve and to still function when opened 'locally'.
(a) Might be achieved by using a local synch'd copy of the source file, assuming path translation might be supported, however that does not address (b) as another's shared file cannot be synch'd along side ones own ... something which DROPBOX does without issue.