I'm trying to find out how to do a mail merge thats a bit more complicated then a normal mail merge and was wondering if someone could point me in the right direction/provide me with the correct search term.

I want to be able to enter in a reference number and have the rest of the information auto fill in my form that pulls from Access.

I was thinking that Id just want to do a Mail merge but I dont know if theres a better way.