Mail Merge opens blank word not excel data

[MareePW60]

Hi everyone

I'm doing a lot of largish mail merges at work and have a reoccurring issue keeps happening. I create my word document (letter) then select my excel data and instead of the excel data opening it opens a blank word doc and I get the message that the data couldn't be found or has been moved.

Please help, this is most frustrating

Thanks in advance.

Maree

[Keebellah]

Hi, welcome to the forum.
Not much information to go on by.
Theblank word document is the merge file but you haven't 'told' the merge file what fields and data you need/want
You will have to use the mail merge menu in Word where you can select the source file and then the fields and then if it's to be saved into a new file or whatever.
Maybe read on mail merge with Excel, there are plenty of hits if you query Google with samples

[MareePW60]

Hi and thank you for getting in touch. I had the workplace IT team have a look at it and turns out it’s my profile. They are amending this on Monday.

[Keebellah]

I know for a fact that user profiles can be an issue.
Wonder how this affects the mail merge, but let’s hope they can fix it for you
Just curious, do you save files on your desktop or just links to files?