There are no vampire spells that work because vampires do not exist.
The myth about vampires began because people in the Middle Ages did not understand what happened when the human body was dead and buried and mistook the normal processes of death for the body becoming a vampire. See this article for some scientific information: https://ww2.kqed.org/quest/2012/10/29/science-behind-vampire-myths/
Vampires in such folklore were feared and hated. Then along came people such as Anne Rice and the woman who wrote the Twilight series and all of a sudden vampires became glamorous and sparkly. But these are fantasy novels and Hollywood films, not the truth.
A Natural History of Vampires : https://blogs.scientificamerican.com/primate-diaries/a-natural-history-of-vampires/
Science Behind the Vampire Myths : https://ww2.kqed.org/quest/2012/10/29/science-behind-vampire-myths/
The Restless Dead: Vampires and Decomposition : http://home.benecke.com/publications/the-restless-dead-vampires-and-decomposition
Myths and Scientific Realities About Vampires : http://home.benecke.com/publications/the-restless-dead-vampires-and-decomposition
Books and Articles:
Barber, P. (1987). Forensic Pathology and the European Vampire, Journal of Folklore Research 24 (1), 1-32. URL: http://www.jstor.org/stable/3814375Barber, Paul. (2006). Vampires, Burial, and Death: Folklore and Reality; With a New Preface.
Gmez-Alonso J. (1998). Rabies: a possible explanation for the vampire legend. Neurology, 51 (3), 856-9. PMID: 9748039