Trevor G
Registered User.
- Local time
- Today, 12:58
- Joined
- Oct 1, 2009
- Messages
- 2,341
Hi everyone,
I have been looking to create a form to email a query list, this works well but I have been asked to add an extra feature. A frame with option buttons providing from a list of 5 options and the sender wants to be able to select which one to be included. The list is positions:
Option frame list name is optPosition with a list choice of:
1 = Admin
2 = Sales
3 = Resources
4 = Finance
5 = Director
I can't work out how to add this into the code. Currently when I display the emails it shows the name as indicated below in red, the line of code is shown below:
.HTMLBody = "<font face=""Arial"" size=3>" & Forms!frmmail!MainText.Value & "</Font><br><br>" & "<font face=""Viner Hand ITC"" size=3 color=""blue"">" & Forms!frmmail!sender.Value & "</font><br> & forms!frmail!optPosition.1" & "<br><font face=""Arial"" size=3 color=""blue"">Test Email<br></Font> "
Can someone take a look and guide me please.
I have been looking to create a form to email a query list, this works well but I have been asked to add an extra feature. A frame with option buttons providing from a list of 5 options and the sender wants to be able to select which one to be included. The list is positions:
Option frame list name is optPosition with a list choice of:
1 = Admin
2 = Sales
3 = Resources
4 = Finance
5 = Director
I can't work out how to add this into the code. Currently when I display the emails it shows the name as indicated below in red, the line of code is shown below:
.HTMLBody = "<font face=""Arial"" size=3>" & Forms!frmmail!MainText.Value & "</Font><br><br>" & "<font face=""Viner Hand ITC"" size=3 color=""blue"">" & Forms!frmmail!sender.Value & "</font><br> & forms!frmail!optPosition.1" & "<br><font face=""Arial"" size=3 color=""blue"">Test Email<br></Font> "
Can someone take a look and guide me please.