I got this vba from some youtube videos but the email column was not able to read and become the mailto function.
Purpose of this worksheet:
To send email to customer when column N is going to expire. Email to be send on every 15th of the month for the next month expiring. Example, on 15th Aug will send email to customers whose VPC expiring in Sep and 15 Sep to send email to those expiring in Oct.
I had made a column H to show what data I will need to be place in the email. Ideally, I need not create this column H if this can be done by vba but I think just to make this column is for an easier vba to work.
I will need to customized the subject so that I know which customers I had sent.
Can someone teach me how to point the vba to extract the data and how to join the fixed header with different data.
Attachment 475920Please Login or Register to view this content.
Don't know why the attaching of the excel file is not working. The email is on column G, due date is on column N, Name of the person is on column F, vehicle is on column J. After I submit the thread and see if I can attach.
Bookmarks