The final edition of the Newsquest-owned title will be published on 2 September.
The company is to begin printing its daily broadsheet The Herald and pro-independence title The National seven days a week from September 9.
It was announced earlier this month that The Herald and The Sunday Herald teams were to be merged.
Newsquest said the decision followed “extensive market research and feedback from readers and advertisers alike that their needs were not being fully met on a Sunday”.
Newsquest Scotland managing director Graham Morrison said: “This is a highly competitive industry and to be successful requires innovation, diversification and investment to ensure we deliver the media and marketing platforms our customers want.
“It has been clear for some time that Herald readers wanted a seven-day offering with closer alignment of the brand and the title’s editorial values on a Sunday.
The Sunday Herald, launched in 1999 was the only national newspaper to back independence during the 2014 referendum campaign.