Note: The other languages of the website are Google-translated. Back to English

Kako v Outlook vstaviti vsa imena prejemnikov v telo e-pošte?

Včasih boste morali pri sestavljanju e-pošte v Outlooku v telo sporočila vstaviti imena vseh prejemnikov. Imena lahko seveda kopirate in prilepite v telo enega za drugim. Vendar je zelo dolgočasno, če je treba nalepiti na desetine imen prejemnikov. V tem članku bom govoril o enostavnem načinu reševanja tega dela v programu Outlook.

V Outlook vstavite vsa imena prejemnikov v telo e-pošte s kodo VBA

V Outlook vstavite vsa imena prejemnikov v telo e-pošte s kodo VBA

Naslednja koda VBA vam lahko pomaga, da v telo sporočila vstavite vsa imena prejemnikov iz polja To, naredite naslednje:

1. Zaženite Outlook in pridržite ALT + F11 tipke za odpiranje Microsoft Visual Basic za aplikacije okno.

2. Kliknite Vstavi > Moduliin prilepite naslednjo kodo v Moduli Okno.

Koda VBA: Vstavite imena prejemnikov v telo sporočila:

Sub InsertRecipientNamesToBody()
Dim xMailItem As Outlook.MailItem
Dim xRecipient As Outlook.Recipient
Dim xRecipAddress, xRecipNames, xRecipName, xFilterAddr As String
Dim xItems As Outlook.Items
Dim i As Integer
Dim xFoundContact As Outlook.ContactItem
Dim xDoc As Word.Document
On Error Resume Next
Set xMailItem = Outlook.ActiveInspector.CurrentItem
For Each xRecipient In xMailItem.Recipients
    xRecipAddress = xRecipient.Address
    Set xItems = Application.Session.GetDefaultFolder(olFolderContacts).Items
    For i = 1 To 3
        xFilterAddr = "[Email" & i & "Address] = " & xRecipAddress
        Set xFoundContact = xItems.Find(xFilterAddr)
        If Not (xFoundContact Is Nothing) Then
           xRecipNames = xRecipNames & xFoundContact.FullName & Chr(10)
           Exit For
        End If
    If (xFoundContact Is Nothing) Then
       xRecipName = Split(xRecipAddress, "@")(0)
       xRecipNames = xRecipNames & xRecipName & Chr(10)
    End If
Set xDoc = xMailItem.GetInspector.WordEditor
xDoc.Content.InsertAfter xRecipNames
Set xMailItem = Nothing
Set xRecipient = Nothing
Set xItems = Nothing
Set xFoundContact = Nothing
End Sub

3. And then still in the Microsoft Visual Basic for Applications window, click Tools > References to go to the References-Project1 dialog box, and check Microsoft Word Object Library option from the Available References list box, see screenshot:

4. Then click OK to close the dialog, now, you should add this code to the Quick Access Toolbar.

5. Create a new message by clicking New Email, in the Message window, click Customize Quick Access Toolbar icon, and select More Commands, see screenshot:

6. In the Outlook Options dialog box:

(1.) Select Macros from the Choose commands from drop down list;

(2.) And then choose the VBA code name which you have inserted just now;

(3.) Click Add button to add the code into the Customize Quick Access Toolbar list box.

7. And then a macro icon is displayed into the Quick Access Toolbar as following screenshot shown:

8. Now, when you click the macro icon, the recipient names from the To field will be inserted into the message body as following screenshot shown:

Kutools for Outlook - Brings 100 Advanced Features to Outlook, and Make Work Much Easier!

  • Auto CC/BCC by rules when sending email; Auto Forward Multiple Emails by custom; Auto Reply without exchange server, and more automatic features...
  • BCC Warning - show message when you try to reply all if your mail address is in the BCC list; Remind When Missing Attachments, and more remind features...
  • Reply (All) With All Attachments in the mail conversation; Reply Many Emails in seconds; Auto Add Greeting when reply; Add Date into subject...
  • Attachment Tools: Manage All Attachments in All Mails, Auto Detach, Compress All, Rename All, Save All... Quick Report, Count Selected Mails...
  • Powerful Junk Emails by custom; Remove Duplicate Mails and Contacts... Enable you to do smarter, faster and better in Outlook.
shot kutools outlook kutools tab 1180x121
shot kutools outlook kutools plus tab 1180x121
Comments (0)
No ratings yet. Be the first to rate!
There are no comments posted here yet
Leave your comments
Posting as Guest
Rate this post:
0   Characters
Suggested Locations