Email VB and Macros

New Contributor

Hi Everyone,


I am trying to create a VB with very little VB experience.

I would like the VB to create an email (refer to email tab) for each different email address that is on “sheet 1” with the data relating to their customer code if it has a ‘x’ in the send price advice code column. 

Each email would need to show as per the below but would change pending on their customer code and the pricing that is showing on ‘sheet 1’


Can VB do this or should I be looking at a different program?


Any help, suggestion or advise would be greatly appreciated. 

Thank you. :):)

2 Replies


I worked out an old code of mine a bit.

Not entirely to your liking (I don't have the time), but you can adjust it to your liking.

It is actually set up very simply, so that every layperson can understand it, including me :))



I would be happy to know if I could help.



I know I don't know anything (Socrates)


* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.

Hi @NikolinoDE


Thank you for the reply, unfortunately i need a separate email for each customer number to be sent with the details changing per customer/day. 


Thank you for your help though.