Hey - really hoping someone can help me.

I've got an excel sheet with the data I need to mail merge, and have set up the word document & populated the merge fields.

Ideally I want a single macro that will run through in a single click from the excel file, right through to being ready to print the fully merged document, but I'm getting nowhere with it. Ive instead tried to split things down to 2 macros - one in excel, one in word. The first one works. The second runs, but then still prompts for other data to be entered when I try to use the macro

This is the excel macro

Set appWD = CreateObject("Word.Application")
appWD.Visible = True

appWD.Documents.Open Filename:="C:\Users\Sarah\Documents\NHS\Paeds\ST3 - BWH\BWH Handover\ITU.docm"

The trouble is when the file opens the source reference for the mail merge is not active. The 2nd macro has to select the data source and tell the file to generate the printable copy. Below is the macro I've currently got - at present I'm running it with a button, but would like to make it automated in the long term

ActiveDocument.MailMerge.OpenDataSource Name:= _
"C:\Users\Sarah\Documents\NHS\Paeds\ST3 - BWH\BWH Handover\Version 5 - test.xlsm" _
, ConfirmConversions:=False, ReadOnly:=False, LinkToSource:=True, _
AddToRecentFiles:=False, PasswordDocument:="", PasswordTemplate:="", _
WritePasswordDocument:="", WritePasswordTemplate:="", Revert:=False, _
Format:=wdOpenFormatAuto, Connection:="Entire Spreadsheet", SQLStatement _
:="", SQLStatement1:="", SubType:=wdMergeSubTypeOther
ActiveDocument.MailMerge.ViewMailMergeFieldCodes = wdToggle
With ActiveDocument.MailMerge
.Destination = wdSendToNewDocument
.SuppressBlankLines = True
With .DataSource
.FirstRecord = wdDefaultFirstRecord
.LastRecord = wdDefaultLastRecord
End With
.Execute Pause:=False
End With

But when I run the 2nd macro I get the following :

Error.jpg

I then have to click "handover$" and click "OK" before I get the merged file I was aiming for

As this is to be used by colleagues who are not at all excel / macro savy my aim is to make the process as simple as possible, ideally with a single click.

Any help or suggesions you could offer would be most welcome