Outlook 2007 Distibution E-mail Structure

Status
Not open for further replies.

LMS

Senior Member
Outlook version
Email Account
Exchange Server
I think heard in the past, but can't remember how to do it, whern I create the distribution list and an email to all of them in the distribution list, there might be a way when the email is sent in the bcc area so they don't all see all email addresses and/or names, but in To area, each contact that gets an email, it shows just their name/email. I is there a way to do this? Thanks very much !!
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Outlook doesn't do the 'only their name in the to field' part when you use DLs - if you use BCC field, the To field will be empty. If you want to use their name in the To field, you need to use mail merge. Except outlook can't mail merge DLs. But... macros to the recue. :)

Mail merge to a contract group
 

LMS

Senior Member
Outlook version
Email Account
Exchange Server
Thanks so much...so I tried exactly what you showed me, created a test distrbution list with just a few contacts and different email addresses...and it works...

So what do I change in the macro so that it creates the email from a template email I created...so if I have a specific email I want to send to many people, I create the disribution list of those people and then just select the list, and run the macro?

And very important, it is there something to add so it automatcially sends it so I don't have to click on send of each email set up?

This would wonderful as I send many email templates to major lists and this would be so much faster....thanks so so much to the Smart Woman!!:D
 

LMS

Senior Member
Outlook version
Email Account
Exchange Server
I found the way to use the template so here is the code that uses a template but it opens up each email to each contact of the distribution list...so can we change it so that it automaticaly sends the email....that way when I have distribution list of a 100 contacts, it sends them to each one as if it is not a distibution, and I don't have to click on each one to send. That would super!!!

Sub Merge_to_Group2()

Dim o_list As Object

Dim objMsg As MailItem
' select or open the distribution list

Set o_list = GetCurrentItem()

For i = 1 To o_list.MemberCount

Set objMsg = Application.CreateItemFromTemplate("C:\Users\Name\AppData\Roaming\Microsoft\Templates\E-mail Template.oft")

With objMsg
.To = o_list.GetMember(i).Address
.Display

End With

Set objMsg = Nothing

Next

End Sub
 

LMS

Senior Member
Outlook version
Email Account
Exchange Server
To All,

I changed the words Set objMsg =Nothing to objMsg.send and it did it opens the email for each contact and sends them automaically...
 

LMS

Senior Member
Outlook version
Email Account
Exchange Server
Now....if there is not a distribution list but I select different contacts in a folder.....just highlighting them....can we change the code it does the same thing for the contacts select? As I might have a list to send to, but not a distribution list.
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
W Transfer Outlook 2016 autocomplete file to Outlook 2007 Using Outlook 1
C Outlook 2007 Removing then adding account restores junk email processing Using Outlook 0
S Outlook 2007 crash linked to gdiplus.dll Using Outlook 0
S Outlook 2007 - Automatic purge fail Using Outlook 0
J outlook 2007 doesn't let me choose which .pst to search Using Outlook 2
D Outlook 2007 vs. Outlook 2010 -- ToDo Bar Using Outlook 0
D Outlook 2007 on 365 Using Outlook.com accounts in Outlook 2
S Macro for other actions - Outlook 2007 Outlook VBA and Custom Forms 23
S Verwendung von Outlook 2007 Using Outlook 0
A Arthur needs help with 2007 Outlook e-mail Using Outlook.com accounts in Outlook 3
M PST import from Outlook 2007 to 2010 - Address Book contacts all in 1 group Using Outlook 4
S outlook 2007 calendar search Using Outlook 6
B Migrate Outlook 2007 to Office 365 Using Outlook 3
X I have met my waterloo trying to resolve embedded graphics problem with outlook 2007 and now 2016 Using Outlook 1
R Outlook 2007 only loads some appointments Using Outlook 0
C Move Outlook 2007 to new PC with Outlook 365 Using Outlook 3
J Outlook 2007 Hide Messages Option not Available Using Outlook 2
S Outlook 2007 Calendar instant search problem. Windows 7 Using Outlook 4
S Outlook 2007 Calendar instant search problem. Windows 7 Using Outlook 0
B Server errors Outlook 2007 Using Outlook 1
S Reboot of frozen windows7 results in changed outlook 2007 settings Using Outlook 1
S Outlook 2007 printing wrong email address at top of page Using Outlook 8
M Configure outlook 2007 to accept digital signatures Using Outlook 2
D Outlook 2007 crashes when opening an email Using Outlook 2
R New chap saying hello and needing advice on Outlook 2007 thumbnails Using Outlook 3
icacream From Outlook 2007 to 2016 ! Using Outlook 9
vodkasoda Object could not be found Error in Outlook 2007 Outlook VBA and Custom Forms 5
S Outlook 2007: Address Cards allow entering text! Why? Using Outlook 3
S View Appointment in Text Wrap in Outlook 2007 Month Calendar View Using Outlook 0
L Outlook 2007 Separate the Send/Receive functions Using Outlook 2
M Outlook 2007 Contacts Glitch: Creating a new email Using Outlook 1
C Move from Outlook 2007 Enterprise (MOE) to Outlook Pro plus 2007 Using Outlook 1
J reinstalling Outlook 2007 asking for user name & password Using Outlook 14
P outlook addin unloaded in office 2007 Using Outlook 0
B Fonts in Outlook 2007 Using Outlook 4
R Add Exchange Account to existing POP3 Outlook 2007 Profile Using Outlook 0
C out of space in file group Outlook 2007 Using Outlook 2
A Moving archived contents in Outlook 2007 back into working folders Using Outlook 0
P Outlook 2007 Email Categorization using VBA Outlook VBA and Custom Forms 1
M Unable to Configure Gmail Account in Outlook 2007 Using Outlook 1
R Outlook 2007 or 2010 - Lock Down Functionality Outlook VBA and Custom Forms 3
S Outlook 2007, windows 10 Font size Using Outlook 1
Diane Poremsky Manually create a POP3 account in Outlook 2007 Using Outlook 0
J Can Click to Drag Custom Form Field But Cannot Drop When Designing in Outlook 2007 Outlook VBA and Custom Forms 2
L Outlook 2007 Font Using Outlook 3
J Outlook 2007 connector and Windows 10 Using Outlook 3
R Outlook 2007 - Shared Accounts and Resources without Exchange Server Using Outlook 0
L Outlook 2007 - Macro Re Search Using Outlook 16
D Outlook (Office) 2007 & Windows 10 Pro Using Outlook 6
MattC Problem with Outlook 2007 & iCloud / duplicate tasks Using Outlook 1

Similar threads

Top