Re: Outlook Email Merge Problems

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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" <Dalekauai@xxxxxxxxx> wrote in message news:8d9eac04-93d6-4f4d-a0d3-edd1b8462b53@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Jun 16, 9:45 pm, "Russ Valentine [MVP-Outlook]" <russ...@xxxxxxxxx>
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" <Daleka...@xxxxxxxxx> wrote in message

news:c532bb40-fa3d-424c-ba9d-9f56eb1b824b@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Jun 16, 6:35 pm, "Russ Valentine [MVP-Outlook]" <russ...@xxxxxxxxx>
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" <Daleka...@xxxxxxxxx> wrote in message

>news:613ae71c-e676-4982-bc13-087edcdde628@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> On Jun 16, 4:55 pm, "Russ Valentine [MVP-Outlook]" <russ...@xxxxxxxxx>
> 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" <Daleka...@xxxxxxxxx> wrote in message

> >news:2020d55d-42a1-4bb1-8f3b-69f32eed6e60@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

> > >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.

.

Relevant Pages

  • Re: Outlook Email Merge Problems
    ... from an Excel sheet. ... Are you saying that even regular email messages you send fail? ... messages and shows as being sent in my sent folder. ... the emails are received by the recipients. ...
    (microsoft.public.outlook)
  • Re: Outlook Email Merge Problems
    ... This is not an Outlook issue. ... Are you saying that even regular email messages you send fail? ... messages and shows as being sent in my sent folder. ... the emails are received by the recipients. ...
    (microsoft.public.outlook)
  • Re: Outlook Email Merge Problems
    ... You don't "select recipients" from an Excel sheet. ... >> messages and shows as being sent in my sent folder. ... All my regular email messages sent are just fine. ...
    (microsoft.public.outlook)
  • Re: e mailing attatchments excel always come out as scrambled words?
    ... If you are sending from Outlook Express and recipients have MS Outlook, ... Gord Dibben MS Excel MVP ... "dino32" wrote: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: How can I export Outlook folders to Word format?
    ... it sure would be great if you could export email messages from Microsoft ... Outlook to a Microsoft Word format. ... It seems like if you can export to Excel ...
    (microsoft.public.outlook.general)