Forum Discussion

Madeleine_Chapman's avatar
Madeleine_Chapman
Copper Contributor
May 26, 2021

Email VB and Macros

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

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor

    Madeleine_Chapman 

    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.

     

    Nikolino

    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.

    • Madeleine_Chapman's avatar
      Madeleine_Chapman
      Copper Contributor

      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. 🙂

Resources