mailmerge problem. trying to send a mass e mail list for 400, but zuuwk 11/11/2008 12:31:00 PM Hi, please help me. I'm getting the following message during the final steps in Office 2003. "word cannot merge documents that can be distributed by mail or fax without a vailid mail address" Basically, i inserted a bunch email address i had saved in excel format by use an existing list option. It is only the email address on my list. Please help me. I'm sending the same e mail message to all the recipients, i just don't want each person to see others e mail addresses. Thanks in advance.

Re: mailmerge problem. trying to send a mass e mail list for 400, but "Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> 11/11/2008 1:26:06 PM For mailmerge to email, you need a data source where one column contains the e-mail address you want to use, and you have one e-mail address in that column in each row. So if you have 400 recipients, you need 400 rows. You have to specify the name of the column that contains that address. The error normally means that you have not selected a column. Typically, if you are using the Mail Merge wizard, you would be prompted for that when you click "Electronic Mail" in Step 6 of 6 "Complete the merge," but if you managed to miss that somehow you might see that error. I didn't understand what you had done when I read the following, but maybe you have not set things up that way. [Quoted Text] > Basically, i inserted a bunch email address i had saved in excel format by > use an existing list option. It is only the email address on my list. -- Peter Jamieson http://tips.pjmsn.me.uk "zuuwk" <zuuwk[ at ]discussions.microsoft.com> wrote in message news:9C314243-285E-49D3-B648-FAC8138E4A8A[ at ]microsoft.com... > Hi, please help me. > > I'm getting the following message during the final steps in Office 2003. > "word cannot merge documents that can be distributed by mail or fax > without > a vailid mail address" > > Basically, i inserted a bunch email address i had saved in excel format by > use an existing list option. It is only the email address on my list. > Please help me. I'm sending the same e mail message to all the > recipients, i > just don't want each person to see others e mail addresses. Thanks in > advance.

Re: mailmerge problem. trying to send a mass e mail list for 400, zuuwk 11/11/2008 1:53:01 PM Ok, So what would be the quickest way to mass e maill my 400 contacts the same information without each recepient seeing everyones email address. What about a distribution list? Just so you know, I want to be able to insert or copy/paste my email list at once so that i don't have to enter all 400 contacts in my list. Again I only have their email address in my list no names or address, i'm sure just he email address only should be ok. Thanks for helping me out. "Peter Jamieson" wrote: [Quoted Text] > For mailmerge to email, you need a data source where one column contains the > e-mail address you want to use, and you have one e-mail address in that > column in each row. So if you have 400 recipients, you need 400 rows. You > have to specify the name of the column that contains that address. The error > normally means that you have not selected a column. Typically, if you are > using the Mail Merge wizard, you would be prompted for that when you click > "Electronic Mail" in Step 6 of 6 "Complete the merge," but if you managed to > miss that somehow you might see that error. > > I didn't understand what you had done when I read the following, but maybe > you have not set things up that way. > > > Basically, i inserted a bunch email address i had saved in excel format by > > use an existing list option. It is only the email address on my list. > > > -- > Peter Jamieson > http://tips.pjmsn.me.uk > > "zuuwk" <zuuwk[ at ]discussions.microsoft.com> wrote in message > news:9C314243-285E-49D3-B648-FAC8138E4A8A[ at ]microsoft.com... > > Hi, please help me. > > > > I'm getting the following message during the final steps in Office 2003. > > "word cannot merge documents that can be distributed by mail or fax > > without > > a vailid mail address" > > > > Basically, i inserted a bunch email address i had saved in excel format by > > use an existing list option. It is only the email address on my list. > > Please help me. I'm sending the same e mail message to all the > > recipients, i > > just don't want each person to see others e mail addresses. Thanks in > > advance. > >

Re: mailmerge problem. trying to send a mass e mail list for 400, "Graham Mayor" <gmayor[ at ]REMOVETHISmvps.org> 11/11/2008 2:43:23 PM If you merge to e-mail the recipients will not see who else you have sent the document to. Use the list of e-mail addresses as the data source and when you merge to e-mail select the e-mail field and add a subject. -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> zuuwk wrote: [Quoted Text] > Ok, So what would be the quickest way to mass e maill my 400 contacts > the same information without each recepient seeing everyones email > address. > What about a distribution list? Just so you know, I want to be able > to insert or copy/paste my email list at once so that i don't have to > enter all 400 contacts in my list. Again I only have their email > address in my list no names or address, i'm sure just he email > address only should be ok. Thanks for helping me out. > > "Peter Jamieson" wrote: > >> For mailmerge to email, you need a data source where one column >> contains the e-mail address you want to use, and you have one e-mail >> address in that column in each row. So if you have 400 recipients, >> you need 400 rows. You have to specify the name of the column that >> contains that address. The error normally means that you have not >> selected a column. Typically, if you are using the Mail Merge >> wizard, you would be prompted for that when you click "Electronic >> Mail" in Step 6 of 6 "Complete the merge," but if you managed to >> miss that somehow you might see that error. >> >> I didn't understand what you had done when I read the following, but >> maybe you have not set things up that way. >> >>> Basically, i inserted a bunch email address i had saved in excel >>> format by use an existing list option. It is only the email >>> address on my list. >> >> >> -- >> Peter Jamieson >> http://tips.pjmsn.me.uk >> >> "zuuwk" <zuuwk[ at ]discussions.microsoft.com> wrote in message >> news:9C314243-285E-49D3-B648-FAC8138E4A8A[ at ]microsoft.com... >>> Hi, please help me. >>> >>> I'm getting the following message during the final steps in Office >>> 2003. "word cannot merge documents that can be distributed by mail >>> or fax without >>> a vailid mail address" >>> >>> Basically, i inserted a bunch email address i had saved in excel >>> format by use an existing list option. It is only the email >>> address on my list. Please help me. I'm sending the same e mail >>> message to all the recipients, i >>> just don't want each person to see others e mail addresses. >>> Thanks in advance.