Rod Stewart set to become grandfather for seventh time as daughter, 41, shares sweet pregnancy announcement

The rocker welcomed his sixth grandchild earlier this month