Hi all, I've been sifting through the internet and on here for a week now trying to find an answer or solution to my problem. I want to send a mass of emails to our users that displays their vehicle registration, their business name and their MOT expiry date.


I have an excel sheet showing these details also with their email in the next column. The problem I have is that the same user may have many vehicles (some over 1000) which means that when I try to use mail merge it will send that user 1000 separate emails, which I am sure they would not be happy with.
The spreadsheet looks something like this:
Name Vehicle id expiry email
jbloggs 123456 30/03/20 123@456.com

jbloggs 2345612 03/03/19 123@456.com

jbloggs 81818313 01/01/20 123@456.com

So you get the gist that the email could be listed multiple times but the data on each row is different.

Hope this makes sense.

Regards

Ross