Is it possible to do a "Mail merge" in Outlook??

Hi Diane

Thanks for the response but I am still not clear on the process.

I am able to do the MSWord mail merge part.
What I am struggling with is how I send to the merged record to Outlook,
"merge" the particular record with the associated email address in the "To:"
field, automatically send to that addressee and then move on to the next
merged record.

..... And I want to do all this without any programming skills

Tnx
Peter


"Diane Poremsky {MVP}" wrote:

> if the data is in a format mail merge can use, yes. You do the merge the
> 'normal' way in word but send it to email rather than printing.
>
> --
> Diane Poremsky [MVP - Outlook]
> Author, Teach Yourself Outlook 2003 in 24 Hours
> Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
> Outlook 2007: http://www.slipstick.com/outlook/ol2007/
>
> Outlook Tips by email:
> dailytips-subscribe-request RemoveThis @lists.outlooktips.net
>
> Outlook Tips: http://www.outlook-tips.net/
> Outlook & Exchange Solutions Center: http://www.slipstick.com
> Subscribe to Exchange Messaging Outlook newsletter:
> EMO-NEWSLETTER-SUBSCRIBE-REQUEST RemoveThis @PEACH.EASE.LSOFT.COM
>
> ** Please include your Outlook version, Account type, and Windows Version
> when requesting assistance **
>
>
>
>
> "Peter" <Peter RemoveThis @discussions.microsoft.com> wrote in message
> news:BD3053E9-9D64-40AC-AA9F-B7F2B20F8D35@microsoft.com...
> > I have a long distribution list (230 names) and would like to sen
> > customised
> > emails to each of these names. Is it in any way possible to do a "mail
> > merge", similar to that done in MSWord, so that I can take from a (Excel
> > or
> > MSWord) database/Table an email address and add to it specific text and
> > combine the bits into a unique email that goes to each of the names on the
> > distribution list?
> >
> > I hope this is clear bottom line is that I have 230 names and 230 chunks
> > of
> > information that I want to use to create 230 "unique" emails and I do not
> > want to do them one by one
> >
> > Tnx!!
> >
> > Peter
>

Diane
Hi again

I have been experimenting using the info you sent and have worked out how to
do it TNX!!

One more question though. If I do the merge in MSWord and then send to
email is it possible to add file attachments to the mail merged email? If so
where and how is the attachment specified.

If I could do this too it would be the cherry on the top and my life would
be bliss!

Tnx
Peter


"Diane Poremsky {MVP}" wrote:

> if the data is in a format mail merge can use, yes. You do the merge the
> 'normal' way in word but send it to email rather than printing.
>
> --
> Diane Poremsky [MVP - Outlook]
> Author, Teach Yourself Outlook 2003 in 24 Hours
> Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
> Outlook 2007: http://www.slipstick.com/outlook/ol2007/
>
> Outlook Tips by email:
> dailytips-subscribe-request.TakeThisOut@lists.outlooktips.net
>
> Outlook Tips: http://www.outlook-tips.net/
> Outlook & Exchange Solutions Center: http://www.slipstick.com
> Subscribe to Exchange Messaging Outlook newsletter:
> EMO-NEWSLETTER-SUBSCRIBE-REQUEST.TakeThisOut@PEACH.EASE.LSOFT.COM
>
> ** Please include your Outlook version, Account type, and Windows Version
> when requesting assistance **
>
>
>
>
> "Peter" <Peter.TakeThisOut@discussions.microsoft.com> wrote in message
> news:BD3053E9-9D64-40AC-AA9F-B7F2B20F8D35@microsoft.com...
> > I have a long distribution list (230 names) and would like to sen
> > customised
> > emails to each of these names. Is it in any way possible to do a "mail
> > merge", similar to that done in MSWord, so that I can take from a (Excel
> > or
> > MSWord) database/Table an email address and add to it specific text and
> > combine the bits into a unique email that goes to each of the names on the
> > distribution list?
> >
> > I hope this is clear bottom line is that I have 230 names and 230 chunks
> > of
> > information that I want to use to create 230 "unique" emails and I do not
> > want to do them one by one
> >
> > Tnx!!
> >
> > Peter
>

No, mail merge does not support attachments. You'd have to use VBA or a 3rd
party tool.
links to the vba sample and tools are here:
http://www.slipstick.com/addins/massmail.asp

--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:
dailytips-subscribe-request RemoveThis @lists.outlooktips.net

Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newsletter:
EMO-NEWSLETTER-SUBSCRIBE-REQUEST RemoveThis @PEACH.EASE.LSOFT.COM

** Please include your Outlook version, Account type, and Windows Version
when requesting assistance **




"Peter" <Peter RemoveThis @discussions.microsoft.com> wrote in message
news:1C456786-DC75-4939-B09A-29D886B36068@microsoft.com...
> Diane
> Hi again
>
> I have been experimenting using the info you sent and have worked out how
> to
> do it TNX!!
>
> One more question though. If I do the merge in MSWord and then send to
> email is it possible to add file attachments to the mail merged email? If
> so
> where and how is the attachment specified.
>
> If I could do this too it would be the cherry on the top and my life would
> be bliss!
>
> Tnx
> Peter
>
>
> "Diane Poremsky {MVP}" wrote:
>
>> if the data is in a format mail merge can use, yes. You do the merge
>> the
>> 'normal' way in word but send it to email rather than printing.
>>
>> --
>> Diane Poremsky [MVP - Outlook]
>> Author, Teach Yourself Outlook 2003 in 24 Hours
>> Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
>> Outlook 2007: http://www.slipstick.com/outlook/ol2007/
>>
>> Outlook Tips by email:
>> dailytips-subscribe-request RemoveThis @lists.outlooktips.net
>>
>> Outlook Tips: http://www.outlook-tips.net/
>> Outlook & Exchange Solutions Center: http://www.slipstick.com
>> Subscribe to Exchange Messaging Outlook newsletter:
>> EMO-NEWSLETTER-SUBSCRIBE-REQUEST RemoveThis @PEACH.EASE.LSOFT.COM
>>
>> ** Please include your Outlook version, Account type, and Windows Version
>> when requesting assistance **
>>
>>
>>
>>
>> "Peter" <Peter RemoveThis @discussions.microsoft.com> wrote in message
>> news:BD3053E9-9D64-40AC-AA9F-B7F2B20F8D35@microsoft.com...
>> > I have a long distribution list (230 names) and would like to sen
>> > customised
>> > emails to each of these names. Is it in any way possible to do a "mail
>> > merge", similar to that done in MSWord, so that I can take from a
>> > (Excel
>> > or
>> > MSWord) database/Table an email address and add to it specific text and
>> > combine the bits into a unique email that goes to each of the names on
>> > the
>> > distribution list?
>> >
>> > I hope this is clear bottom line is that I have 230 names and 230
>> > chunks
>> > of
>> > information that I want to use to create 230 "unique" emails and I do
>> > not
>> > want to do them one by one
>> >
>> > Tnx!!
>> >
>> > Peter
>>

Tnx Diane

This looks promising - you've made my day!

Peter


"Diane Poremsky {MVP}" wrote:

> No, mail merge does not support attachments. You'd have to use VBA or a 3rd
> party tool.
> links to the vba sample and tools are here:
> http://www.slipstick.com/addins/massmail.asp
>
> --
> Diane Poremsky [MVP - Outlook]
> Author, Teach Yourself Outlook 2003 in 24 Hours
> Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
> Outlook 2007: http://www.slipstick.com/outlook/ol2007/
>
> Outlook Tips by email:
> dailytips-subscribe-request.TakeThisOut@lists.outlooktips.net
>
> Outlook Tips: http://www.outlook-tips.net/
> Outlook & Exchange Solutions Center: http://www.slipstick.com
> Subscribe to Exchange Messaging Outlook newsletter:
> EMO-NEWSLETTER-SUBSCRIBE-REQUEST.TakeThisOut@PEACH.EASE.LSOFT.COM
>
> ** Please include your Outlook version, Account type, and Windows Version
> when requesting assistance **
>
>
>
>
> "Peter" <Peter.TakeThisOut@discussions.microsoft.com> wrote in message
> news:1C456786-DC75-4939-B09A-29D886B36068@microsoft.com...
> > Diane
> > Hi again
> >
> > I have been experimenting using the info you sent and have worked out how
> > to
> > do it TNX!!
> >
> > One more question though. If I do the merge in MSWord and then send to
> > email is it possible to add file attachments to the mail merged email? If
> > so
> > where and how is the attachment specified.
> >
> > If I could do this too it would be the cherry on the top and my life would
> > be bliss!
> >
> > Tnx
> > Peter
> >
> >
> > "Diane Poremsky {MVP}" wrote:
> >
> >> if the data is in a format mail merge can use, yes. You do the merge
> >> the
> >> 'normal' way in word but send it to email rather than printing.
> >>
> >> --
> >> Diane Poremsky [MVP - Outlook]
> >> Author, Teach Yourself Outlook 2003 in 24 Hours
> >> Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
> >> Outlook 2007: http://www.slipstick.com/outlook/ol2007/
> >>
> >> Outlook Tips by email:
> >> dailytips-subscribe-request.TakeThisOut@lists.outlooktips.net
> >>
> >> Outlook Tips: http://www.outlook-tips.net/
> >> Outlook & Exchange Solutions Center: http://www.slipstick.com
> >> Subscribe to Exchange Messaging Outlook newsletter:
> >> EMO-NEWSLETTER-SUBSCRIBE-REQUEST.TakeThisOut@PEACH.EASE.LSOFT.COM
> >>
> >> ** Please include your Outlook version, Account type, and Windows Version
> >> when requesting assistance **
> >>
> >>
> >>
> >>
> >> "Peter" <Peter.TakeThisOut@discussions.microsoft.com> wrote in message
> >> news:BD3053E9-9D64-40AC-AA9F-B7F2B20F8D35@microsoft.com...
> >> > I have a long distribution list (230 names) and would like to sen
> >> > customised
> >> > emails to each of these names. Is it in any way possible to do a "mail
> >> > merge", similar to that done in MSWord, so that I can take from a
> >> > (Excel
> >> > or
> >> > MSWord) database/Table an email address and add to it specific text and
> >> > combine the bits into a unique email that goes to each of the names on
> >> > the
> >> > distribution list?
> >> >
> >> > I hope this is clear bottom line is that I have 230 names and 230
> >> > chunks
> >> > of
> >> > information that I want to use to create 230 "unique" emails and I do
> >> > not
> >> > want to do them one by one
> >> >
> >> > Tnx!!
> >> >
> >> > Peter
> >>
>