email merge Gary76 12/11/2008 12:16:07 PM I want to do an email megre that sends personalised emails to a number of individuals. If I try and use my email contacts as Data Source, then I seem to be only able to include data from the Contacts File in the merged mail. I need to include other data (currently in Excel). Can I merge to Outlook from EXcel and pick the email addresses up from Excel? Gary

Re: email merge "Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> 12/11/2008 2:02:26 PM [Quoted Text] > If I try and use my email contacts as Data Source, then I seem to be only > able to include data from the Contacts File in the merged mail. Yes. If you have everything you need for personalisation in Excel, and you have the e-mail address for each contact in Excel, then you should still be OK - select your Excel worksheet as the data source and merge to Outlook. If you have some of the personalisation data that you need in Excel, and some in Outlook contacts, there is no really straightforward, general-purpose approach - if all you need is the email address out of Outlook and the number of contacts is not too large, perhaps even manually updating your Excel sheet manually with the e-mail addresses would be enough. If you also have Access, and you also have columns that would let you do a reliable join (e.g. if you have Lastname and Firstname in both Contacts and Excel and no duplicate Lastname/Firstname combinations) then you could consider creating two linked tables in Access and taking things from there. -- Peter Jamieson http://tips.pjmsn.me.uk "Gary76" <Gary76[ at ]discussions.microsoft.com> wrote in message news:71052041-CBC5-4AF9-8966-3A1AC3DCB461[ at ]microsoft.com... >I want to do an email megre that sends personalised emails to a number of > individuals. > > If I try and use my email contacts as Data Source, then I seem to be only > able to include data from the Contacts File in the merged mail. > > I need to include other data (currently in Excel). > > Can I merge to Outlook from EXcel and pick the email addresses up from > Excel? > > Gary

Re: email merge Gary76 12/12/2008 12:24:01 PM Thanks Peter I can get the email addresses into my Excel datafile, but how do I get the email address into the To: field in Outlook? I think I am almost there!! Gary "Peter Jamieson" wrote: [Quoted Text] > > If I try and use my email contacts as Data Source, then I seem to be only > > able to include data from the Contacts File in the merged mail. > > Yes. > > If you have everything you need for personalisation in Excel, and you have > the e-mail address for each contact in Excel, then you should still be OK - > select your Excel worksheet as the data source and merge to Outlook. > > If you have some of the personalisation data that you need in Excel, and > some in Outlook contacts, there is no really straightforward, > general-purpose approach - if all you need is the email address out of > Outlook and the number of contacts is not too large, perhaps even manually > updating your Excel sheet manually with the e-mail addresses would be > enough. If you also have Access, and you also have columns that would let > you do a reliable join (e.g. if you have Lastname and Firstname in both > Contacts and Excel and no duplicate Lastname/Firstname combinations) then > you could consider creating two linked tables in Access and taking things > from there. > -- > Peter Jamieson > http://tips.pjmsn.me.uk > > "Gary76" <Gary76[ at ]discussions.microsoft.com> wrote in message > news:71052041-CBC5-4AF9-8966-3A1AC3DCB461[ at ]microsoft.com... > >I want to do an email megre that sends personalised emails to a number of > > individuals. > > > > If I try and use my email contacts as Data Source, then I seem to be only > > able to include data from the Contacts File in the merged mail. > > > > I need to include other data (currently in Excel). > > > > Can I merge to Outlook from EXcel and pick the email addresses up from > > Excel? > > > > Gary > >

Re: email merge "Graham Mayor" <gmayor[ at ]REMOVETHISmvps.org> 12/12/2008 2:09:10 PM If you merge to e-mail, you will be prompted for the field that contains the e-mail addresses. -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Gary76 wrote: [Quoted Text] > Thanks Peter > > I can get the email addresses into my Excel datafile, but how do I > get the email address into the To: field in Outlook? > > I think I am almost there!! > > Gary > > "Peter Jamieson" wrote: > >>> If I try and use my email contacts as Data Source, then I seem to >>> be only able to include data from the Contacts File in the merged >>> mail. >> >> Yes. >> >> If you have everything you need for personalisation in Excel, and >> you have the e-mail address for each contact in Excel, then you >> should still be OK - select your Excel worksheet as the data source >> and merge to Outlook. >> >> If you have some of the personalisation data that you need in Excel, >> and some in Outlook contacts, there is no really straightforward, >> general-purpose approach - if all you need is the email address out >> of Outlook and the number of contacts is not too large, perhaps even >> manually updating your Excel sheet manually with the e-mail >> addresses would be enough. If you also have Access, and you also >> have columns that would let you do a reliable join (e.g. if you have >> Lastname and Firstname in both Contacts and Excel and no duplicate >> Lastname/Firstname combinations) then you could consider creating >> two linked tables in Access and taking things from there. >> -- >> Peter Jamieson >> http://tips.pjmsn.me.uk >> >> "Gary76" <Gary76[ at ]discussions.microsoft.com> wrote in message >> news:71052041-CBC5-4AF9-8966-3A1AC3DCB461[ at ]microsoft.com... >>> I want to do an email megre that sends personalised emails to a >>> number of individuals. >>> >>> If I try and use my email contacts as Data Source, then I seem to >>> be only able to include data from the Contacts File in the merged >>> mail. >>> >>> I need to include other data (currently in Excel). >>> >>> Can I merge to Outlook from EXcel and pick the email addresses up >>> from Excel? >>> >>> Gary

Re: email merge Gary76 12/12/2008 2:54:16 PM Brilliant! Thanks. "Graham Mayor" wrote: [Quoted Text] > If you merge to e-mail, you will be prompted for the field that contains the > e-mail addresses. > > -- > <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Graham Mayor - Word MVP > > My web site www.gmayor.com > Word MVP web site http://word.mvps.org > <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > > > Gary76 wrote: > > Thanks Peter > > > > I can get the email addresses into my Excel datafile, but how do I > > get the email address into the To: field in Outlook? > > > > I think I am almost there!! > > > > Gary > > > > "Peter Jamieson" wrote: > > > >>> If I try and use my email contacts as Data Source, then I seem to > >>> be only able to include data from the Contacts File in the merged > >>> mail. > >> > >> Yes. > >> > >> If you have everything you need for personalisation in Excel, and > >> you have the e-mail address for each contact in Excel, then you > >> should still be OK - select your Excel worksheet as the data source > >> and merge to Outlook. > >> > >> If you have some of the personalisation data that you need in Excel, > >> and some in Outlook contacts, there is no really straightforward, > >> general-purpose approach - if all you need is the email address out > >> of Outlook and the number of contacts is not too large, perhaps even > >> manually updating your Excel sheet manually with the e-mail > >> addresses would be enough. If you also have Access, and you also > >> have columns that would let you do a reliable join (e.g. if you have > >> Lastname and Firstname in both Contacts and Excel and no duplicate > >> Lastname/Firstname combinations) then you could consider creating > >> two linked tables in Access and taking things from there. > >> -- > >> Peter Jamieson > >> http://tips.pjmsn.me.uk > >> > >> "Gary76" <Gary76[ at ]discussions.microsoft.com> wrote in message > >> news:71052041-CBC5-4AF9-8966-3A1AC3DCB461[ at ]microsoft.com... > >>> I want to do an email megre that sends personalised emails to a > >>> number of individuals. > >>> > >>> If I try and use my email contacts as Data Source, then I seem to > >>> be only able to include data from the Contacts File in the merged > >>> mail. > >>> > >>> I need to include other data (currently in Excel). > >>> > >>> Can I merge to Outlook from EXcel and pick the email addresses up > >>> from Excel? > >>> > >>> Gary > > >

Re: email merge Gary76 12/15/2008 12:31:01 PM One final (I hope!) question... Can I get a .cc in my merge to Outlook? "Gary76" wrote: [Quoted Text] > Brilliant! Thanks. > > "Graham Mayor" wrote: > > > If you merge to e-mail, you will be prompted for the field that contains the > > e-mail addresses. > > > > -- > > <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > > Graham Mayor - Word MVP > > > > My web site www.gmayor.com > > Word MVP web site http://word.mvps.org > > <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > > > > > > Gary76 wrote: > > > Thanks Peter > > > > > > I can get the email addresses into my Excel datafile, but how do I > > > get the email address into the To: field in Outlook? > > > > > > I think I am almost there!! > > > > > > Gary > > > > > > "Peter Jamieson" wrote: > > > > > >>> If I try and use my email contacts as Data Source, then I seem to > > >>> be only able to include data from the Contacts File in the merged > > >>> mail. > > >> > > >> Yes. > > >> > > >> If you have everything you need for personalisation in Excel, and > > >> you have the e-mail address for each contact in Excel, then you > > >> should still be OK - select your Excel worksheet as the data source > > >> and merge to Outlook. > > >> > > >> If you have some of the personalisation data that you need in Excel, > > >> and some in Outlook contacts, there is no really straightforward, > > >> general-purpose approach - if all you need is the email address out > > >> of Outlook and the number of contacts is not too large, perhaps even > > >> manually updating your Excel sheet manually with the e-mail > > >> addresses would be enough. If you also have Access, and you also > > >> have columns that would let you do a reliable join (e.g. if you have > > >> Lastname and Firstname in both Contacts and Excel and no duplicate > > >> Lastname/Firstname combinations) then you could consider creating > > >> two linked tables in Access and taking things from there. > > >> -- > > >> Peter Jamieson > > >> http://tips.pjmsn.me.uk > > >> > > >> "Gary76" <Gary76[ at ]discussions.microsoft.com> wrote in message > > >> news:71052041-CBC5-4AF9-8966-3A1AC3DCB461[ at ]microsoft.com... > > >>> I want to do an email megre that sends personalised emails to a > > >>> number of individuals. > > >>> > > >>> If I try and use my email contacts as Data Source, then I seem to > > >>> be only able to include data from the Contacts File in the merged > > >>> mail. > > >>> > > >>> I need to include other data (currently in Excel). > > >>> > > >>> Can I merge to Outlook from EXcel and pick the email addresses up > > >>> from Excel? > > >>> > > >>> Gary > > > > > >

Re: email merge "Graham Mayor" <gmayor[ at ]REMOVETHISmvps.org> 12/15/2008 2:02:15 PM Not easily. The simplest approach would be to use the MailMerge toolkit add-in from mapilabs - http://www.mapilab.com/outlook/mail_merge/ -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Gary76 wrote: [Quoted Text] > One final (I hope!) question... > > Can I get a .cc in my merge to Outlook? > > "Gary76" wrote: > >> Brilliant! Thanks. >> >> "Graham Mayor" wrote: >> >>> If you merge to e-mail, you will be prompted for the field that >>> contains the e-mail addresses. >>> >>> -- >>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<> >>> Graham Mayor - Word MVP >>> >>> My web site www.gmayor.com >>> Word MVP web site http://word.mvps.org >>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<> >>> >>> >>> Gary76 wrote: >>>> Thanks Peter >>>> >>>> I can get the email addresses into my Excel datafile, but how do I >>>> get the email address into the To: field in Outlook? >>>> >>>> I think I am almost there!! >>>> >>>> Gary >>>> >>>> "Peter Jamieson" wrote: >>>> >>>>>> If I try and use my email contacts as Data Source, then I seem to >>>>>> be only able to include data from the Contacts File in the merged >>>>>> mail. >>>>> >>>>> Yes. >>>>> >>>>> If you have everything you need for personalisation in Excel, and >>>>> you have the e-mail address for each contact in Excel, then you >>>>> should still be OK - select your Excel worksheet as the data >>>>> source and merge to Outlook. >>>>> >>>>> If you have some of the personalisation data that you need in >>>>> Excel, and some in Outlook contacts, there is no really >>>>> straightforward, general-purpose approach - if all you need is >>>>> the email address out of Outlook and the number of contacts is >>>>> not too large, perhaps even manually updating your Excel sheet >>>>> manually with the e-mail addresses would be enough. If you also >>>>> have Access, and you also have columns that would let you do a >>>>> reliable join (e.g. if you have Lastname and Firstname in both >>>>> Contacts and Excel and no duplicate Lastname/Firstname >>>>> combinations) then you could consider creating two linked tables >>>>> in Access and taking things from there. -- >>>>> Peter Jamieson >>>>> http://tips.pjmsn.me.uk >>>>> >>>>> "Gary76" <Gary76[ at ]discussions.microsoft.com> wrote in message >>>>> news:71052041-CBC5-4AF9-8966-3A1AC3DCB461[ at ]microsoft.com... >>>>>> I want to do an email megre that sends personalised emails to a >>>>>> number of individuals. >>>>>> >>>>>> If I try and use my email contacts as Data Source, then I seem to >>>>>> be only able to include data from the Contacts File in the merged >>>>>> mail. >>>>>> >>>>>> I need to include other data (currently in Excel). >>>>>> >>>>>> Can I merge to Outlook from EXcel and pick the email addresses up >>>>>> from Excel? >>>>>> >>>>>> Gary

Re: email merge Gary76 12/16/2008 10:13:02 AM I will investigate the MapiLab solution. Many thanks for your time and expertise! Gary "Graham Mayor" wrote: [Quoted Text] > Not easily. The simplest approach would be to use the MailMerge toolkit > add-in from mapilabs - http://www.mapilab.com/outlook/mail_merge/ > > -- > <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Graham Mayor - Word MVP > > My web site www.gmayor.com > Word MVP web site http://word.mvps.org > <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > > > Gary76 wrote: > > One final (I hope!) question... > > > > Can I get a .cc in my merge to Outlook? > > > > "Gary76" wrote: > > > >> Brilliant! Thanks. > >> > >> "Graham Mayor" wrote: > >> > >>> If you merge to e-mail, you will be prompted for the field that > >>> contains the e-mail addresses. > >>> > >>> -- > >>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > >>> Graham Mayor - Word MVP > >>> > >>> My web site www.gmayor.com > >>> Word MVP web site http://word.mvps.org > >>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > >>> > >>> > >>> Gary76 wrote: > >>>> Thanks Peter > >>>> > >>>> I can get the email addresses into my Excel datafile, but how do I > >>>> get the email address into the To: field in Outlook? > >>>> > >>>> I think I am almost there!! > >>>> > >>>> Gary > >>>> > >>>> "Peter Jamieson" wrote: > >>>> > >>>>>> If I try and use my email contacts as Data Source, then I seem to > >>>>>> be only able to include data from the Contacts File in the merged > >>>>>> mail. > >>>>> > >>>>> Yes. > >>>>> > >>>>> If you have everything you need for personalisation in Excel, and > >>>>> you have the e-mail address for each contact in Excel, then you > >>>>> should still be OK - select your Excel worksheet as the data > >>>>> source and merge to Outlook. > >>>>> > >>>>> If you have some of the personalisation data that you need in > >>>>> Excel, and some in Outlook contacts, there is no really > >>>>> straightforward, general-purpose approach - if all you need is > >>>>> the email address out of Outlook and the number of contacts is > >>>>> not too large, perhaps even manually updating your Excel sheet > >>>>> manually with the e-mail addresses would be enough. If you also > >>>>> have Access, and you also have columns that would let you do a > >>>>> reliable join (e.g. if you have Lastname and Firstname in both > >>>>> Contacts and Excel and no duplicate Lastname/Firstname > >>>>> combinations) then you could consider creating two linked tables > >>>>> in Access and taking things from there. -- > >>>>> Peter Jamieson > >>>>> http://tips.pjmsn.me.uk > >>>>> > >>>>> "Gary76" <Gary76[ at ]discussions.microsoft.com> wrote in message > >>>>> news:71052041-CBC5-4AF9-8966-3A1AC3DCB461[ at ]microsoft.com... > >>>>>> I want to do an email megre that sends personalised emails to a > >>>>>> number of individuals. > >>>>>> > >>>>>> If I try and use my email contacts as Data Source, then I seem to > >>>>>> be only able to include data from the Contacts File in the merged > >>>>>> mail. > >>>>>> > >>>>>> I need to include other data (currently in Excel). > >>>>>> > >>>>>> Can I merge to Outlook from EXcel and pick the email addresses up > >>>>>> from Excel? > >>>>>> > >>>>>> Gary > > >