![]() |
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 wrote some VBA to create about 100 EMails, paste the contents of Excel
worksheets into the bodies, place distribution lists in To and BCC, and save the Emails to the Drafts folder. The distribution lists do not populate and turn bold/underlined as they do when manually selected and inserted. In order to get them to do so, the user has to open each Email and wait -- some will populate themselves, and others have to be manually selected. I tried to fix this issue by using the ResolveAll method as shown below, but the distribution lists still are not bold/underlined. Set objEmail = objOutlook.CreateItem(0) ' olMailItem Set myRecipients = objEmail.Recipients With objEmail .To = strto .CC = strCC .BCC = strBCC .Subject = strSubject .Body = strbody .Save End With If Not myRecipients.ResolveAll Then For Each myRecipient In myRecipients myRecipient.Resolve If Not myRecipient.Resolved Then MsgBox myRecipient.Name End If Next End If Can anyone tell me what I'm doing wrong? Thanks, Randy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Distribution list that includes other distribution lists. | Mike | Outlook and VBA | 2 | January 10th 08 06:41 AM |
Adding distribution lists to a master distribution list. | OldCoder | Outlook - Using Forms | 1 | January 8th 08 09:01 PM |
Distribution Lists | Sarah | Outlook - Using Contacts | 1 | December 1st 06 06:28 PM |
Adding mutliple distribution lists into a distribution list? | Abel | Outlook - Using Contacts | 2 | August 30th 06 05:51 PM |
Distribution Lists sourced from linked SharePoint Contact Lists | Marcela | Outlook - Using Contacts | 4 | July 17th 06 12:08 AM |