The mass shooting took place 10 minutes after midnight as Sucheep Sornsung joined his wife's family to ring in the New Year in the southern province of Chumphon, police said Tuesday.
Sucheep was "heavily" drunk when he pulled out his pistol at the table in the beauty parlour where the party was being hosted in Phato district, police said.
"All of the victims were his family members including his nine-year-old son and six-year-old daughter," Lieutenant Colonel Larp Kampapan of Phato police told AFP.
"They were shot either in the head or the torso... he was angry that as the son-in-law he was not being made welcome by his wife's family."
The gunman then turned the weapon on himself.
The other four victims were two men and two women aged between 47 and 71.
Thailand has high rates of gun ownership and petty personal disputes, romantic and business rivalries are often resolved with bullets.