> Great, I'm guessing that the "Merge to Email" button was the missing pice of
> the puzzle that had me confused. Let me go look at it and I'll let you know
> how it goes.
>
> Since it's a mail merge, I'm guessing that each message will appear to the
> recipient as if that message was sent only to them, as far as the text that
> appears in the TO: fiield, is that correct?
>
>
> "Sue Mosher [MVP-Outlook]" wrote:
>
>> Yes, the Write Your Letter step is where you write the body of the email message that you want to send.
>>
>> It's probably easiest to display the Mail Merge toolbar, which has the Merge to E-mail button on it. When you click it, you'll see a dialog that asks you which of the fields from the data source contains the email addresses.
>>
>> "Rebecca"
discussions.microsoft.com> wrote in message news:44E0501E-8593-4578-815E-8E2CBF1EF396@microsoft.com...>>> Okay, I think I know how to get started, but not how to complete it. How do
>>> I send it as an email? Here are the steps that I think I do know so far, are
>>> they right up to that point?
>>>
>>> Open a blank Word document
>>>
>>> Choose Tools> Letters and Mailings> Mail Merge
>>>
>>> On the right, choose the radio button “E-mail messages”
>>>
>>> On the right, Choose “Next: Starting Document”
>>>
>>> On the right, Choose “Next: Select Recipients”
>>>
>>> On the right, Choose “Browse”
>>>
>>> Use drop-down box to find the location of the .TXT file, and choose it
>>>
>>> Answer “OK” to all the Data Source windows until you are back to your blank
>>> document
>>>
>>> Choose “Next: Write Your Letter” and type in the text of your email address
>>>
>>> Choose “Next: Complete the Merge”
>>>
>>> At this point, it doesn't look right to me. Then how do I send that as an
>>> email? It seems to want to go to a printer to be printed.
>>>
>>> During the "Write your letter"part, is there a place where I'm supposed to
>>> embed the email address?
>>>
>>>
>>> "Sue Mosher [MVP-Outlook]" wrote:
>>>
>>>> The location of the database doesn't matter. All that should be required is that a connection can be made to it using ODBC, etc.
>>>>
>>>> If I had a .txt list of email addresses, I'd run a mail merge in Word and use that list as the data source.
>>>>
>>>> --
>>>> Sue Mosher, Outlook MVP
>>>> Author of Configuring Microsoft Outlook 2003
>>>>
http://www.turtleflock.com/olconfig/index.htm
>>>> and Microsoft Outlook Programming - Jumpstart for
>>>> Administrators, Power Users, and Developers
>>>>
http://www.outlookcode.com/jumpstart.aspx
>>>>
>>>> "Rebecca"
discussions.microsoft.com> wrote in message news:07871C5C-14A4-4153-97D8-28F23B300C11@microsoft.com...>>>>> Thanks, Sue, but the database is DATATRIEVE on our HP OpenVMS Alpha system,
>>>>> it's not Windows.
>>>>>
>>>>> I don't understand the implication when you say "If each list is for
>>>>> one-time use, a DL would be an expensive solution in terms of time spent.".
>>>>> Therefore, what SHOULD I do? If you yourself needed to send a one-time-only
>>>>> email to about 20 or 30 people who were not already in your Contacts, and
>>>>> someone had given you the list of names and emails as a fixed-column ..TXT,
>>>>> what steps would you take to send that email?
>>>>>
>>>>>
>>>>> "Sue Mosher [MVP-Outlook]" wrote:
>>>>>
>>>>>> If the data is already in a database, then putting it into Outlook is an extra step you may not need. Word's mail merge feature can use a database as its data source.
>>>>>>
>>>>>> If each list is for one-time use, a DL would be an expensive solution in terms of time spent.
>>>>>>
>>>>>> --
>>>>>> Sue Mosher, Outlook MVP
>>>>>> Author of Configuring Microsoft Outlook 2003
>>>>>>
http://www.turtleflock.com/olconfig/index.htm
>>>>>> and Microsoft Outlook Programming - Jumpstart for
>>>>>> Administrators, Power Users, and Developers
>>>>>>
http://www.outlookcode.com/jumpstart.aspx
>>>>>>
>>>>>> "Rebecca"
discussions.microsoft.com> wrote in message news:A8E6D393-6617-4C96-AFAD-BCC77EE4E1DD@microsoft.com...>>>>>>> Thanks, Russ, I'll look at these. For this purpose, creating Contacts would
>>>>>>> not be correct, I don't think. These are temporary DL lists to send
>>>>>>> one-time-only reminders to customers whose insurance premiums are due the
>>>>>>> following month. I'm extracting the name and email info from a database and
>>>>>>> putting it in a DL, unless you know a way to import name and email into a
>>>>>>> Contacts folder that's unique?
>>>>>>>
>>>>>>> "Russ Valentine [MVP-Outlook]" wrote:
>>>>>>>
>>>>>>>>> I've done a mail merge where the form is an MS-Word doc, the data is in MS
>>>>>>>>> Excel and the output doc is an MS-Word letter that we print on paper.
>>>>>>>>> I've
>>>>>>>>> never done a mail merge where the form is an email, the data is a DL and
>>>>>>>>> the
>>>>>>>>> output doc is an email. Where can I find instructions to do that?
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> "Russ Valentine [MVP-Outlook]" wrote:
>>>>>>>>>
>>>>>>>>>> Two options:
>>>>>>>>>> 1. Use a mail merge if you want each recipient to see only their own
>>>>>>>>>> name.
>>>>>>>>>> 2. Create a dummy Contact that has the name of your DL and put it in the
>>>>>>>>>> To:
>>>>>>>>>> field while you put the actual DL in the BCC field.
>>>>>>>>>> --
>>>>>>>>>> Russ Valentine
>>>>>>>>>> [MVP-Outlook]
>>>>>>>>>> "Rebecca"
discussions.microsoft.com> wrote in message
>>>>>>>>>> news:678B419B-E783-473E-8B31-3F48669AD314@microsoft.com...>>>>>>>>>>> What is the BEST way to send the same email message to a large group of
>>>>>>>>>>> customers, but control what the recipient sees in the "To:" field of
>>>>>>>>>>> the
>>>>>>>>>>> email they receive?
>>>>>>>>>>>
>>>>>>>>>>> Sample distribution list "MY CUSTOMERS"
>>>>>>>>>>> Miles Smith (msmith@
abbott.com)
>>>>>>>>>>> Michael Dell (mdell@
dell.com)
>>>>>>>>>>> Steve Ballmer (sballmer@
microsoft.com)
>>>>>>>>>>>
>>>>>>>>>>> I know by default that when I choose a distribution list such as
>>>>>>>>>>> "MY CUSTOMERS" in the "To:" field when I create the message, it looks
>>>>>>>>>>> like
>>>>>>>>>>> To: + MY CUSTOMERS on my screen, but when the email is received by each
>>>>>>>>>>> person,
>>>>>>>>>>> their received email shows every individual name and email:
>>>>>>>>>>> To: Miles Smith (msmith@
abbot.com; Michael Dell (mdell@
dell.com); Steve
>>>>>>>>>>> Ballmer
>>>>>>>>>>> (sballmer@
microsoft.com)
>>>>>>>>>>>
>>>>>>>>>>> I would rather have the recipient's email display just the distribution
>>>>>>>>>>> list
>>>>>>>>>>> name
>>>>>>>>>>> To: MY CUSTOMERS
>>>>>>>>>>>
>>>>>>>>>>> or ideally display with only their own name
>>>>>>>>>>> To: Michael Dell
>>>>>>>>>>> even though it was sent to tons of people.
>>>>>>>>>>>
>>>>>>>>>>> When creating the message, if I put nothing in the "To:" field and I
>>>>>>>>>>> put
>>>>>>>>>>> MY
>>>>>>>>>>> CUSTOMERS in the BCC field, it does hide all the names, but the message
>>>>>>>>>>> looks
>>>>>>>>>>> too blank and impersonal:
>>>>>>>>>>> From: Becky
>>>>>>>>>>> To:
>>>>>>>>>>> Cc:
>>>>>>>>>>> Subject: whatever
>>>>>>>>>>>
>>>>>>>>>>> If I put my own name in the To: field and the distribution list in the
>>>>>>>>>>> BCC
>>>>>>>>>>> then the received email really looks weird:
>>>>>>>>>>> From: Becky
>>>>>>>>>>> To: Becky
>>>>>>>>>>> CC:
>>>>>>>>>>> Subject: whatever
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>
>>>>
>>
