![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
![]()
I am creating a custom Outlook email form and I keep hitting a snag with the
section that populates the “To” field. The form will be used as an interoffice email form to update our Project Leads on project progress/issues. The user needs to be able to select any variation of Project Leads (approx 15 recipients) and have the names populate in the To field as recipients. When I use a list box to select various emails from the list (a button as an event to populate field), it works, but I get the email addresses in the ‘To’ line as one long string with commas dividing the emails. Outlook doesn’t automatically fix this because it sees it as one email instead of various recipients. This method would work if I could get the “possible value” field (in the field properties, value tab) to hold spaces or semicolons. This would break up the email addresses and there would be no issues, but Outlook uses the semicolons as a divider of lines for values of the list box so it removes the spaces and semicolons. Is there any way I can force it to keep a semi-colon or a space? As an alternative, I have tried creating individual check boxes for each email. However I couldn’t find an easy way to populate the “To” field if the box was checked, so I believe this method would require me to write VB code. I am not against writing code, but it has been so many years since I wrote code, I am unsure where to start. Any ideas???? FYI, I am creating the form in Outlook 2007, but had the same issue in Outlook 2003 and all of the users are internal Exchange (2003) users. -- Maria |
Ads |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Populate task field based on value of other field | jparker | Outlook and VBA | 9 | March 12th 09 04:50 PM |
how do i automaticlly populate the from field? | Marcos | Outlook - Using Forms | 2 | January 15th 08 07:33 PM |
Populate Message field based on custom field | Kryer | Outlook - Using Forms | 8 | September 7th 07 11:19 PM |
Populate CC field from dropdown list & resolve against Outlook GAL | Yvetta | Outlook and VBA | 1 | April 9th 06 07:44 PM |
Populate Company field from Contact field in custom task form | Sue Mosher [MVP-Outlook] | Outlook - Using Forms | 0 | January 20th 06 08:37 PM |