S
Sal Iaccarino
A while back I asked if it WORD was able to send a merged letter as an
e-mail. The response was YES, however, when I send, all my recipients
receive two copies of the same e-mail. The steps are as follows:
1. I go into WORD and create my document.
2. I then click on Tools-->Mail Merge, which brings up the Mail Merger
Helper.
3. I click on the Create button-->Form Letters--->Active Window.
4. Next I click on Get Data button--->Open Data Source--->then WMNGPG.xls
(this file contains first name and e-mail address) I click Open
5. A Microsoft Excel Dialog box pops up stating: Named or cell range: Entire
Spreadsheet, I click O.K.
6. It then indicates NO merged fields. I insert merged fields, and click
Merge. A Merge dialog box comes up.
7. I click Merge to: Electronic Mail, then click the Setup button: the Merge
to Setup dialog box comes up and I highlight "Email Address" I fill in the
Subject line and click OK.
8. Eventually It indicates that is trying to send an e-mail to the first
person is Data Source. I have to click OK for each person in the list.
As a result of the above procedure everyone receives two e-mails of same
message.
Is there something obvious to why this is happening?
Thanks for any hints or ideas.
Sal and Eileen
e-mail. The response was YES, however, when I send, all my recipients
receive two copies of the same e-mail. The steps are as follows:
1. I go into WORD and create my document.
2. I then click on Tools-->Mail Merge, which brings up the Mail Merger
Helper.
3. I click on the Create button-->Form Letters--->Active Window.
4. Next I click on Get Data button--->Open Data Source--->then WMNGPG.xls
(this file contains first name and e-mail address) I click Open
5. A Microsoft Excel Dialog box pops up stating: Named or cell range: Entire
Spreadsheet, I click O.K.
6. It then indicates NO merged fields. I insert merged fields, and click
Merge. A Merge dialog box comes up.
7. I click Merge to: Electronic Mail, then click the Setup button: the Merge
to Setup dialog box comes up and I highlight "Email Address" I fill in the
Subject line and click OK.
8. Eventually It indicates that is trying to send an e-mail to the first
person is Data Source. I have to click OK for each person in the list.
As a result of the above procedure everyone receives two e-mails of same
message.
Is there something obvious to why this is happening?
Thanks for any hints or ideas.
Sal and Eileen