I know you can use an Excel spreadsheet as a data source, but you posted in
an Outlook group. This is not an Outlook issue. You are trying to filter
your recipients after you select your data source, and as far as I know,
that can't be done (unless you are using Outlook). Your question is a Word
question. Use their mail merge newsgroup and their many helpful sites on
mail merges.
http://www.gmayor.com/Word_pages.htm
--
Russ Valentine
[MVP-Outlook]
"Dale" wrote in message
...
On Jun 16, 9:45 pm, "Russ Valentine [MVP-Outlook]"
wrote:
Why are you using Excel as your data source? You don't "select recipients"
from an Excel sheet. You tell the merge wizard which field to use as its
data source.
--
Russ Valentine
[MVP-Outlook]"Dale" wrote in message
...
On Jun 16, 6:35 pm, "Russ Valentine [MVP-Outlook]"
wrote:
My question remains unanswered. Do not for an instant think that "I've
followed all the exact steps" tell us anything.
--
Russ Valentine
[MVP-Outlook]"Dale" wrote in message
...
On Jun 16, 4:55 pm, "Russ Valentine [MVP-Outlook]"
wrote:
Until you post your precise configuration and precise steps used to
perform
the merge, there is no way we can tell what you are doing wrong. The
possibilities are endless.
Are you saying that even regular email messages you send fail? If so,
what
makes you think this has anything to do with the merge?
--
Russ Valentine
[MVP-Outlook]"Dale" wrote in message
...
I have no problem sending email merges at work with our ISP. However
at home, using
my ISP, Comcast, I am having problems. I sent an email merge using
Outlook 2007 and Word 2007. The merge blended perfectly, no error
messages and shows as being sent in my sent folder. However, none of
the emails are received by the recipients. I sent 4 test emails to
myself and 3 other accounts and no one received any of the sent
emails. My deduction is that if it's merging correctly and showing
in
my sent folder then the problem is with my ISP however they say they
have no problems. Anyone have any suggestions or any experience with
this. Thanks for your help. Dale- Hide quoted text -
- Show quoted text -
All my regular email messages sent are just fine. The only issues I
have are sending an email merge. I sent 4 test email merges and they
are in the sent folder but never arrive at the recipient. I followed
each test email merge that didn't arrive with a plain email sent
individually all all those did arrive. The email merge is fine it just
never arrives. I've sent merge on Vista Home using Outlook and Word
2003 and 2007 neither works. I've sent on XP using OUtlook and Word
2003 and 2007 and neither work. Comcast is the ISP and using NO 3rd
party SMTP. I've used the merge set-up wizard and followed all the
exact steps. The merge is great and shows up exactly as I want in the
sent folder. The only merge is the email address, no merge of names,
addresses, salutations, etc.- Hide quoted text -
- Show quoted text -
1. Opened Word document that I want to merge
2. Open mail merge in word document
3. Click email messages and click next
4. Click use existing document and click next
5. Click use an existing document for recipients - used Excel name and
email list in columns
6. I browsed desktop until I found excel document. Opened it clicked
on sheet #
7. Selected all 4 recipients and clicked ok
8. I had nothing to write in email message so clicked to preview
emails which I did and all was fine as is.
9.Click complete the merge - message sent to emails, sent to all,
added subject, click ok and they sent
10. Outlook shows sent emails in email sent folder. Recipients did not
receive
This works well at my work email that uses a business email account
with coxmail. Same procedure I used at work, I used at home. It works
well at work not at home.- Hide quoted text -
- Show quoted text -
An excel spreadsheet works well when you have a list of a possible 500
recipient email addresses and you want the same email text to go to
each recipeint without a cc or bc and I merge each email address with
the original text that I want to use.