Add page numbers to Word document created with excel macro

Hi
I've made a macro that create a word document, paste a specific range of cells into it and then send it as an e-mail. That parts works just fine.

But the documents the macro create are often 2 or 3 pages long and i would of cause like to have page numbers in the footer of the word document.

So what I'm looking for is a line of code that add page numbers to the active document in the right side of the footer, something like this:

Please Login or Register  to view this content.

I hope someone can point me in the right direction.

Best regards
Simon