mcpointon
12-11-2016, 06:58 AM
Hello, I am new to VBA coding and would really appreciate some assistance with an Excel VBA coding: looking to send a common email format to different email addresses depending on the drop down, selectable with cell-specific information: cells that trigger the direction of the emal:
If B3 'Oil & Gas' and D3 'WNO' to one group of email addresses and B3 'Offshore Support Vessel' and D3 'WNO' to one group of email addresses from a macro button.
In addition, I would like to include the information in cells B1 - B4 and D2 - D4 in both the Subject and main body text inserted as part of a common email text.
Any help is appreciated.
If B3 'Oil & Gas' and D3 'WNO' to one group of email addresses and B3 'Offshore Support Vessel' and D3 'WNO' to one group of email addresses from a macro button.
In addition, I would like to include the information in cells B1 - B4 and D2 - D4 in both the Subject and main body text inserted as part of a common email text.
Any help is appreciated.