With KOMA-Script version 3.19 or newer and documentclass scrlttr2 there is no need to load an additional package to get page # of ## in your letter(s). You only have to redefine \pagemark using \pageref{\thisletter.lastpage}:
\renewcommand\pagemark{{\usekomafont{pagenumber}%
\pagename\nobreakspace\thepage\nobreakspace
of\nobreakspace\pageref{\thisletter.lastpage}%
}}
If the page number should also be on the first page add the following line:
\setkomavar{firstfoot}{\parbox{\linewidth}{\centering\pagemark}}
MWE:
\documentclass[12pt]{scrlttr2}[2015/10/03]
\setkomavar{firstfoot}{\parbox{\linewidth}{\centering\pagemark}}
\renewcommand\pagemark{{\usekomafont{pagenumber}%
\pagename\nobreakspace\thepage\nobreakspace
of\nobreakspace\pageref{\thisletter.lastpage}%
}}
\usepackage[T1]{fontenc}
\usepackage{fouriernc}
\usepackage{blindtext}
% only for dummytext
\begin{document}
\setkomavar{date}{10th December, 2015}% note that I have changed the koma variable date instead \today
\begin{letter}{To Address}
\opening{Addressee}
\Blindtext[10]
\closing{Yours Sincerely,}
\end{letter}
\end{document}
Or with your headline:
\documentclass[12pt]{scrlttr2}[2015/10/03]
\usepackage{scrlayer-scrpage}
\ohead*{\jobname.tex\hspace{0.5cm}\usekomavar{date}}
\setkomavar{firstfoot}{\parbox{\linewidth}{\centering\pagemark}}
\renewcommand\pagemark{{\usekomafont{pagenumber}%
\pagename\nobreakspace\thepage\nobreakspace
of\nobreakspace\pageref{\thisletter.lastpage}%
}}
\usepackage[T1]{fontenc}
\usepackage{fouriernc}
\usepackage{blindtext}
% only for dummytext
\begin{document}
\setkomavar{date}{10th December, 2015}
\begin{letter}{To Address}
\opening{Addressee}
\Blindtext[10]
\closing{Yours Sincerely,}
\end{letter}
\end{document}
It is also possible to print a second letter with correct pagenumbers in the same document:
\documentclass[12pt]{scrlttr2}[2015/10/03]
\usepackage{scrlayer-scrpage}
\ohead*{\jobname.tex\hspace{0.5cm}\usekomavar{date}}
\setkomavar{firstfoot}{\parbox{\linewidth}{\centering\pagemark}}
\renewcommand\pagemark{{\usekomafont{pagenumber}%
\pagename\nobreakspace\thepage\nobreakspace
of\nobreakspace\pageref{\thisletter.lastpage}%
}}
\usepackage[T1]{fontenc}
\usepackage{fouriernc}
\usepackage{blindtext}% only for dummytext
\begin{document}
\setkomavar{date}{10th December, 2015}
\begin{letter}{To Address}
\opening{Addressee}
\Blindtext[10]
\closing{Yours Sincerely,}
\end{letter}
\begin{letter}{To Address}
\setkomavar{subject}{Second letter}
\opening{Second Addressee}
\Blindtext[20]
\closing{Yours Sincerely,}
\end{letter}
\end{document}
Info for older versions: With KOMA-Script version 3.18 or older you have to load package lastpage.
\documentclass[12pt]{scrlttr2}
\usepackage{lastpage}
%\usepackage{scrlayer-scrpage}
%\ohead*{\jobname.tex\hspace{0.5cm}\usekomavar{date}}
\setkomavar{firstfoot}{\parbox{\linewidth}{\centering\pagemark}}
\renewcommand\pagemark{{\usekomafont{pagenumber}%
\pagename\nobreakspace\thepage\nobreakspace
of\nobreakspace\pageref{\thisletter.lastpage}%
}}
\usepackage[T1]{fontenc}
\usepackage{fouriernc}
\usepackage{blindtext}
\begin{document}
\setkomavar{date}{10th December, 2015}
\begin{letter}{To Address}
\opening{Addressee}
\Blindtext[10]
\closing{Yours Sincerely,}
\end{letter}
\end{document}
Additionally here is an example for other classes with only one pagenumbering scheme. If you load both packages scrlayer-scrpage and lastpage you can redefine \pagemark:
\documentclass{book}
\usepackage{lastpage}
\usepackage{scrlayer-scrpage}
\renewcommand\pagemark{{\usekomafont{pagenumber}%
\pagename\nobreakspace\thepage\nobreakspace
of\nobreakspace\pageref{\thisletter.lastpage}%
}}
\usepackage{blindtext}
\begin{document}
\blinddocument
\end{document}
fancyhdrandscrpage2are trying to do the same functionality for you. That can't work. Use only one of them:scrpage2or betterscrlayer-pageorfancyhdr. – Mensch Dec 13 '15 at 17:47KOMAandfancyhdrdo not really like each other – Dec 13 '15 at 17:48scrlayer-scrpageyou probably want\cfoot{\thepage\ of \pageref{LastPage}}– Johannes_B Dec 13 '15 at 20:46