What it is
Shir HaShirim, written by Shlomo HaMelech, describes the love between Hashem and Klal Yisrael through the image of a bride and groom. Rabbi Akiva taught that "all the Writings are holy, and Shir HaShirim is holy of holies."
When it is said
It is read on Pesach, and many have the custom to say it every Erev Shabbos before Kabbalas Shabbos. Many women say it for forty days for a shidduch, a custom rather than an obligation.
Questions women ask
When is Shir HaShirim read?
On Pesach, and many say it every Friday before Shabbos.
Why do people say Shir HaShirim for forty days?
It is a custom for a shidduch and other needs, recalling the bond of love between Hashem and Klal Yisrael.
Sources
This page explains common practice from mainstream sources. For a halachic question about your own situation, ask your Rav.