I have a Excel database of with names and e-mails. I want to send an e-mail
to each of those people. How do I tell Outlook to use that Excel database to
send an e-mail to each person?
You don't tell Outlook anything; you start a mail merge from within Word,
use Excel as the source and Outlook for sending. Sounds complicated but it's
all automated ;-)
--
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003 http://www.howto-outlook.com/
Outlook FAQ, HowTo, Downloads, Add-Ins and more
Thank you for this response. I wish this was listed some where in the on-line
help. I did several searches and looked in the table of contents and found
nothing.
Microsoft really needs to improve their help system.
"Roady [MVP]" wrote:
> You don't tell Outlook anything; you start a mail merge from within Word,
> use Excel as the source and Outlook for sending. Sounds complicated but it's
> all automated ;-)
>
> --
> Robert Sparnaaij [MVP-Outlook]
> Coauthor, Configuring Microsoft Outlook 2003
> http://www.howto-outlook.com/
> Outlook FAQ, HowTo, Downloads, Add-Ins and more
>
> http://www.msoutlook.info/
> Real World Questions, Real World Answers
>
> -----
>
> "Brian" <Brian@discussions.microsoft.com> wrote in message
> news:0F789896-B7EE-47FD-BBF6-FECAABC266FC@microsoft.com...
> > I have a Excel database of with names and e-mails. I want to send an
> > e-mail
> > to each of those people. How do I tell Outlook to use that Excel database
> > to
> > send an e-mail to each person?
>
--
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003 http://www.howto-outlook.com/
Outlook FAQ, HowTo, Downloads, Add-Ins and more
--
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003 http://www.howto-outlook.com/
Outlook FAQ, HowTo, Downloads, Add-Ins and more
"Brian" <Brian@discussions.microsoft.com> wrote in message
news:8789CC79-A273-4001-B7FD-CFF3E1EC66F0@microsoft.com...
> Thank you for this response. I wish this was listed some where in the
> on-line
> help. I did several searches and looked in the table of contents and found
> nothing.
>
> Microsoft really needs to improve their help system.
>
> "Roady [MVP]" wrote:
>
>> You don't tell Outlook anything; you start a mail merge from within Word,
>> use Excel as the source and Outlook for sending. Sounds complicated but
>> it's
>> all automated ;-)
>>
>> --
>> Robert Sparnaaij [MVP-Outlook]
>> Coauthor, Configuring Microsoft Outlook 2003
>> http://www.howto-outlook.com/
>> Outlook FAQ, HowTo, Downloads, Add-Ins and more
>>
>> http://www.msoutlook.info/
>> Real World Questions, Real World Answers
>>
>> -----
>>
>> "Brian" <Brian@discussions.microsoft.com> wrote in message
>> news:0F789896-B7EE-47FD-BBF6-FECAABC266FC@microsoft.com...
>> > I have a Excel database of with names and e-mails. I want to send an
>> > e-mail
>> > to each of those people. How do I tell Outlook to use that Excel
>> > database
>> > to
>> > send an e-mail to each person?
>>
This was very helpful so far...but I am having problems with the last part.
I will start by saying, I am pretty new to Microsoft 2007...but I am very
familiar with merging documents from prior versions.
I made and checked my document in Word, however, I do not see where I tell
it to send to Outlook. This is new to me.
Can you help?
Debbie
"Roady [MVP]" wrote:
> You don't tell Outlook anything; you start a mail merge from within Word,
> use Excel as the source and Outlook for sending. Sounds complicated but it's
> all automated ;-)
>
> --
> Robert Sparnaaij [MVP-Outlook]
> Coauthor, Configuring Microsoft Outlook 2003
> http://www.howto-outlook.com/
> Outlook FAQ, HowTo, Downloads, Add-Ins and more
>
> http://www.msoutlook.info/
> Real World Questions, Real World Answers
>
> -----
>
> "Brian" <Brian@discussions.microsoft.com> wrote in message
> news:0F789896-B7EE-47FD-BBF6-FECAABC266FC@microsoft.com...
> > I have a Excel database of with names and e-mails. I want to send an
> > e-mail
> > to each of those people. How do I tell Outlook to use that Excel database
> > to
> > send an e-mail to each person?
>
I know the mail merge function of outlook where you create a master word file (which acts as your content) and then roll in the data from excel, it is only good if you want to send a letter and not a letter with an attachment. I have a database in excel and want to send the people a letter along with an attachment (word document), any clue how can I do it quick and short rather than sending them individually?