What's this movie about magic called?

I recall watching a movie a few years back about a couple hiring a sort of a magician to contact the woman's recently deceased wealthy father. I remember the film being quite comedic in nature, with the hired magician serving as the comic relief. Also, the movie ends with the dead father taking over his daughter's husband's body, without the daughter suspecting anything.