Help to send each row of my Excel S/sheet as an individual email in Outlook

[bramsey1]

Hi guys,

Please could somebody help me?

I need a piece of code I can use to create a Macro that outputs each row of my spreadsheet below as an individual Outlook email, to the email address in the column titled "Email" below.

I also need to add the columns titled, "Call", "Type", "Balance" and "Company Name" to the the body of the email.

Call	Hrs Age	Type	Balance	Company Name	Contact Name	Notepad	Email
607229	6253	Licence Renew	224	Volvo Car UK Ltd	Vicky Moores	10:42, 11 Jul 2022 - ZEB - PAYMENT WILL BE MADE ON 18/07/2022 - AS PER VICKY'S EMAIL BELOW. From:	operations@21stcenturyav.com
608531	5993	Licence Renew	20	Glad Tidings Free Pentecostal Church (30251C)	Curlan Cornwall	10:51, 17 Mar 2022 - BRR - Owner was Brendan Ramsey, now Admin group 10:50, 17 Mar 2022 - BRR - Pay	admin@gtfpc.org
613023	5264	Issue NoV Add	93.5	Nocturnal Touring	Mattie Evans	09:16, 14 Dec 2021 - BRR - Owner was Brendan Ramsey, now Admin group 09:16, 14 Dec 2021 - BRR - Pay	mattie@nt-rp.com

 

[bramsey1]

I also need to add some free text to my email which is the same for email sent.

Dear Sir/Madam,

We are still awaiting payment from you for:​

***Body of email*** Please can you provide us with an update? We have recently resent out invoice/card payment links as a gentle reminder. Please note it is a legal requirement for anyone using wireless radio equipment to hold a valid licence. On occasions we carry out site visits to ensure that any frequencies being used for wireless radio equipment are being used legally. Unfortunately, we may also have to look at revoking your company’s access to our Online Portal until such time as this payment is made. Kind Regards, Joe Bloggs​

 

[clrockwell15]

I am trying to get the answer to the same type of problem above in "bramsey" question. I have a profile for all my members. It contains their name, address, phones and email id in each row. I want to be able to mailmerge each row to the email in that particular row. Need to do this to confirm information for each member.