Mail merge to Outlook

[Guest]

I have an access database with info I want to email. I wrote a mail merge
document in word and everything went fine the first time. The emails ended up
in my outlook send folder. I was happy.

Then I changed the query to email a different set of records. It did not
work. Any suggestions. Nothing appears in my sent folder. Any suggestions on
how to trouble shoot this?

 

[Russ Valentine [MVP-Outlook]]

I would suggest stating the steps you used to select your recipient. Include
your version and transport. Include everything else you did differently with
the second merge.

 

[Guest]

I really didn't do anything different the second.

I opened the Word Document I had previously saved. A message came up saying
that it would connect to the Access Database.

I then got the Access password, and data password which i entered correctly

When the document opened. I clicked on Tools, then letters/mailing and then
mail merge.

The mail merge window came up. It was already on step 3 of 6.

I clicked next thru 3, 4, & 5 because the data and letter are correct.

When I got to step 6 I clicked on Electronic Mail, which is the option, and
the one I used previously.

A new window came up with the title Merge to E-mail.

In this window, the To field had the correct field from Access. The mail
format is HTML, and records were all. So I clicked OK.

I got an hourglass for a minute and then closed the word document.

I then went to my inbox, and nothing was listed in the sent list. Please
help!!!!

I would suggest stating the steps you used to select your recipient. Include
your version and transport. Include everything else you did differently with
the second merge.
--
Russ Valentine
[MVP-Outlook]

I have an access database with info I want to email. I wrote a mail merge
document in word and everything went fine the first time. The emails ended
up
in my outlook send folder. I was happy.

Then I changed the query to email a different set of records. It did not
work. Any suggestions. Nothing appears in my sent folder. Any suggestions
on
how to trouble shoot this?

 

[Guest]

I tried a brand new mail merge using a new word document and a new table as
if i was starting fresh. It still didn't work.

 

[Russ Valentine [MVP-Outlook]]

But if you "changed the query to a different set of records" why did you
leave the email address field the same?
Verify that you have Outlook running and set as the default mail client and
configured with a valid transport.
--
Russ Valentine
[MVP-Outlook]

I really didn't do anything different the second.

I opened the Word Document I had previously saved. A message came up
saying
that it would connect to the Access Database.

I then got the Access password, and data password which i entered
correctly

When the document opened. I clicked on Tools, then letters/mailing and
then
mail merge.

The mail merge window came up. It was already on step 3 of 6.

I clicked next thru 3, 4, & 5 because the data and letter are correct.

When I got to step 6 I clicked on Electronic Mail, which is the option,
and
the one I used previously.

A new window came up with the title Merge to E-mail.

In this window, the To field had the correct field from Access. The mail
format is HTML, and records were all. So I clicked OK.

I got an hourglass for a minute and then closed the word document.

I then went to my inbox, and nothing was listed in the sent list. Please
help!!!!

I would suggest stating the steps you used to select your recipient.
Include
your version and transport. Include everything else you did differently
with
the second merge.
--
Russ Valentine
[MVP-Outlook]

I have an access database with info I want to email. I wrote a mail
merge
document in word and everything went fine the first time. The emails
ended
up
in my outlook send folder. I was happy.

Then I changed the query to email a different set of records. It did
not
work. Any suggestions. Nothing appears in my sent folder. Any
suggestions
on
how to trouble shoot this?

 

[Guest]

Let me explain what I did when I said I changed the query. The Query name and
all the field names and the underlying table remained the same. All I did was
change the criteria, so that I emailed records with a different date. The
records appear in the mail merge. They just don't go out the door.

Outlook is definately working. I sent several regular emails.

I am not sure what you mean by default mail client. How can I tell?

I also don't know what you mean by a valid transport. Please explain.

But if you "changed the query to a different set of records" why did you
leave the email address field the same?
Verify that you have Outlook running and set as the default mail client and
configured with a valid transport.
--
Russ Valentine
[MVP-Outlook]

I really didn't do anything different the second.

I opened the Word Document I had previously saved. A message came up
saying
that it would connect to the Access Database.

I then got the Access password, and data password which i entered
correctly

When the document opened. I clicked on Tools, then letters/mailing and
then
mail merge.

The mail merge window came up. It was already on step 3 of 6.

I clicked next thru 3, 4, & 5 because the data and letter are correct.

When I got to step 6 I clicked on Electronic Mail, which is the option,
and
the one I used previously.

A new window came up with the title Merge to E-mail.

In this window, the To field had the correct field from Access. The mail
format is HTML, and records were all. So I clicked OK.

I got an hourglass for a minute and then closed the word document.

I then went to my inbox, and nothing was listed in the sent list. Please
help!!!!

I would suggest stating the steps you used to select your recipient.
Include
your version and transport. Include everything else you did differently
with
the second merge.
--
Russ Valentine
[MVP-Outlook]
I have an access database with info I want to email. I wrote a mail
merge
document in word and everything went fine the first time. The emails
ended
up
in my outlook send folder. I was happy.

Then I changed the query to email a different set of records. It did
not
work. Any suggestions. Nothing appears in my sent folder. Any
suggestions
on
how to trouble shoot this?

 

[Russ Valentine [MVP-Outlook]]

Then explain how and at what point in the merge process you changed the
query.
Merging to Access from Word is not an Outlook issue. Clearly you changed
something between the first merge and the second. We have no idea what. Only
you do.
--
Russ Valentine
[MVP-Outlook]

Let me explain what I did when I said I changed the query. The Query name
and
all the field names and the underlying table remained the same. All I did
was
change the criteria, so that I emailed records with a different date. The
records appear in the mail merge. They just don't go out the door.

Outlook is definately working. I sent several regular emails.

I am not sure what you mean by default mail client. How can I tell?

I also don't know what you mean by a valid transport. Please explain.

But if you "changed the query to a different set of records" why did you
leave the email address field the same?
Verify that you have Outlook running and set as the default mail client
and
configured with a valid transport.
--
Russ Valentine
[MVP-Outlook]

I really didn't do anything different the second.

I opened the Word Document I had previously saved. A message came up
saying
that it would connect to the Access Database.

I then got the Access password, and data password which i entered
correctly

When the document opened. I clicked on Tools, then letters/mailing and
then
mail merge.

The mail merge window came up. It was already on step 3 of 6.

I clicked next thru 3, 4, & 5 because the data and letter are correct.

When I got to step 6 I clicked on Electronic Mail, which is the option,
and
the one I used previously.

A new window came up with the title Merge to E-mail.

In this window, the To field had the correct field from Access. The
mail
format is HTML, and records were all. So I clicked OK.

I got an hourglass for a minute and then closed the word document.

I then went to my inbox, and nothing was listed in the sent list.
Please
help!!!!


:

I would suggest stating the steps you used to select your recipient.
Include
your version and transport. Include everything else you did
differently
with
the second merge.
--
Russ Valentine
[MVP-Outlook]
I have an access database with info I want to email. I wrote a mail
merge
document in word and everything went fine the first time. The emails
ended
up
in my outlook send folder. I was happy.

Then I changed the query to email a different set of records. It did
not
work. Any suggestions. Nothing appears in my sent folder. Any
suggestions
on
how to trouble shoot this?

 

[Guest]

Hi Russ, I did not change the query at any point during the merge process.

When my first merge was completed, I closed Word and Access. I went into
Outlook. [By the way, Outlook was not open when I ran any off the mail
merges].
In Outlook, I check my sent items, and the mail merge records all appeared.
I closed Outlook.

The next day I went into Access. In Access, I changed the criteria of the
query in question. [I assume you know what I mean by criteria] The field
names did not change, nor did the query name change. I then closed Access.

I opened Word and ran the mail merge again. All of the new records
[reflecting the criteria change] appeared. I went thru the mail merge
process. I closed word. I opened Outlook and none of the new records
appeared. I checked with one of the proposed email recipents and they did not
recieve the email.

I have also tried to run a new mail merge. From scratch using a new
database, and new word document. That did not work.

To me the problem appears to be an Outlook issue, since the the issue is
getting into Outlook from Word. Please help Russ!!!!!!!

Then explain how and at what point in the merge process you changed the
query.
Merging to Access from Word is not an Outlook issue. Clearly you changed
something between the first merge and the second. We have no idea what. Only
you do.
--
Russ Valentine
[MVP-Outlook]

Let me explain what I did when I said I changed the query. The Query name
and
all the field names and the underlying table remained the same. All I did
was
change the criteria, so that I emailed records with a different date. The
records appear in the mail merge. They just don't go out the door.

Outlook is definately working. I sent several regular emails.

I am not sure what you mean by default mail client. How can I tell?

I also don't know what you mean by a valid transport. Please explain.

But if you "changed the query to a different set of records" why did you
leave the email address field the same?
Verify that you have Outlook running and set as the default mail client
and
configured with a valid transport.
--
Russ Valentine
[MVP-Outlook]
I really didn't do anything different the second.

I opened the Word Document I had previously saved. A message came up
saying
that it would connect to the Access Database.

I then got the Access password, and data password which i entered
correctly

When the document opened. I clicked on Tools, then letters/mailing and
then
mail merge.

The mail merge window came up. It was already on step 3 of 6.

I clicked next thru 3, 4, & 5 because the data and letter are correct.

When I got to step 6 I clicked on Electronic Mail, which is the option,
and
the one I used previously.

A new window came up with the title Merge to E-mail.

In this window, the To field had the correct field from Access. The
mail
format is HTML, and records were all. So I clicked OK.

I got an hourglass for a minute and then closed the word document.

I then went to my inbox, and nothing was listed in the sent list.
Please
help!!!!


:

I would suggest stating the steps you used to select your recipient.
Include
your version and transport. Include everything else you did
differently
with
the second merge.
--
Russ Valentine
[MVP-Outlook]
I have an access database with info I want to email. I wrote a mail
merge
document in word and everything went fine the first time. The emails
ended
up
in my outlook send folder. I was happy.

Then I changed the query to email a different set of records. It did
not
work. Any suggestions. Nothing appears in my sent folder. Any
suggestions
on
how to trouble shoot this?

 

[Russ Valentine [MVP-Outlook]]

It is not likely an Outlook issue. Assuming you made no changes to your
Outlook profile's configuration, it is upstream from there. As you can tell,
a message that is created correctly and given a valid electronic address
will be sent by Outlook. Sorry I can't help. Have you tried doing your merge
from Outlook to make sure you have it invoked?
--
Russ Valentine
[MVP-Outlook]

Hi Russ, I did not change the query at any point during the merge process.

When my first merge was completed, I closed Word and Access. I went into
Outlook. [By the way, Outlook was not open when I ran any off the mail
merges].
In Outlook, I check my sent items, and the mail merge records all
appeared.
I closed Outlook.

The next day I went into Access. In Access, I changed the criteria of the
query in question. [I assume you know what I mean by criteria] The field
names did not change, nor did the query name change. I then closed Access.

I opened Word and ran the mail merge again. All of the new records
[reflecting the criteria change] appeared. I went thru the mail merge
process. I closed word. I opened Outlook and none of the new records
appeared. I checked with one of the proposed email recipents and they did
not
recieve the email.

I have also tried to run a new mail merge. From scratch using a new
database, and new word document. That did not work.

To me the problem appears to be an Outlook issue, since the the issue is
getting into Outlook from Word. Please help Russ!!!!!!!

Then explain how and at what point in the merge process you changed the
query.
Merging to Access from Word is not an Outlook issue. Clearly you changed
something between the first merge and the second. We have no idea what.
Only
you do.
--
Russ Valentine
[MVP-Outlook]

Let me explain what I did when I said I changed the query. The Query
name
and
all the field names and the underlying table remained the same. All I
did
was
change the criteria, so that I emailed records with a different date.
The
records appear in the mail merge. They just don't go out the door.

Outlook is definately working. I sent several regular emails.

I am not sure what you mean by default mail client. How can I tell?

I also don't know what you mean by a valid transport. Please explain.


:

But if you "changed the query to a different set of records" why did
you
leave the email address field the same?
Verify that you have Outlook running and set as the default mail
client
and
configured with a valid transport.
--
Russ Valentine
[MVP-Outlook]
I really didn't do anything different the second.

I opened the Word Document I had previously saved. A message came up
saying
that it would connect to the Access Database.

I then got the Access password, and data password which i entered
correctly

When the document opened. I clicked on Tools, then letters/mailing
and
then
mail merge.

The mail merge window came up. It was already on step 3 of 6.

I clicked next thru 3, 4, & 5 because the data and letter are
correct.

When I got to step 6 I clicked on Electronic Mail, which is the
option,
and
the one I used previously.

A new window came up with the title Merge to E-mail.

In this window, the To field had the correct field from Access. The
mail
format is HTML, and records were all. So I clicked OK.

I got an hourglass for a minute and then closed the word document.

I then went to my inbox, and nothing was listed in the sent list.
Please
help!!!!


:

I would suggest stating the steps you used to select your
recipient.
Include
your version and transport. Include everything else you did
differently
with
the second merge.
--
Russ Valentine
[MVP-Outlook]
I have an access database with info I want to email. I wrote a
mail
merge
document in word and everything went fine the first time. The
emails
ended
up
in my outlook send folder. I was happy.

Then I changed the query to email a different set of records. It
did
not
work. Any suggestions. Nothing appears in my sent folder. Any
suggestions
on
how to trouble shoot this?

 

[Guest]

So after all this the official answer from Microsoft is .... No my yob!
Wonderful.

It is not likely an Outlook issue. Assuming you made no changes to your
Outlook profile's configuration, it is upstream from there. As you can tell,
a message that is created correctly and given a valid electronic address
will be sent by Outlook. Sorry I can't help. Have you tried doing your merge
from Outlook to make sure you have it invoked?
--
Russ Valentine
[MVP-Outlook]

Hi Russ, I did not change the query at any point during the merge process.

When my first merge was completed, I closed Word and Access. I went into
Outlook. [By the way, Outlook was not open when I ran any off the mail
merges].
In Outlook, I check my sent items, and the mail merge records all
appeared.
I closed Outlook.

The next day I went into Access. In Access, I changed the criteria of the
query in question. [I assume you know what I mean by criteria] The field
names did not change, nor did the query name change. I then closed Access.

I opened Word and ran the mail merge again. All of the new records
[reflecting the criteria change] appeared. I went thru the mail merge
process. I closed word. I opened Outlook and none of the new records
appeared. I checked with one of the proposed email recipents and they did
not
recieve the email.

I have also tried to run a new mail merge. From scratch using a new
database, and new word document. That did not work.

To me the problem appears to be an Outlook issue, since the the issue is
getting into Outlook from Word. Please help Russ!!!!!!!

Then explain how and at what point in the merge process you changed the
query.
Merging to Access from Word is not an Outlook issue. Clearly you changed
something between the first merge and the second. We have no idea what.
Only
you do.
--
Russ Valentine
[MVP-Outlook]
Let me explain what I did when I said I changed the query. The Query
name
and
all the field names and the underlying table remained the same. All I
did
was
change the criteria, so that I emailed records with a different date.
The
records appear in the mail merge. They just don't go out the door.

Outlook is definately working. I sent several regular emails.

I am not sure what you mean by default mail client. How can I tell?

I also don't know what you mean by a valid transport. Please explain.


:

But if you "changed the query to a different set of records" why did
you
leave the email address field the same?
Verify that you have Outlook running and set as the default mail
client
and
configured with a valid transport.
--
Russ Valentine
[MVP-Outlook]
I really didn't do anything different the second.

I opened the Word Document I had previously saved. A message came up
saying
that it would connect to the Access Database.

I then got the Access password, and data password which i entered
correctly

When the document opened. I clicked on Tools, then letters/mailing
and
then
mail merge.

The mail merge window came up. It was already on step 3 of 6.

I clicked next thru 3, 4, & 5 because the data and letter are
correct.

When I got to step 6 I clicked on Electronic Mail, which is the
option,
and
the one I used previously.

A new window came up with the title Merge to E-mail.

In this window, the To field had the correct field from Access. The
mail
format is HTML, and records were all. So I clicked OK.

I got an hourglass for a minute and then closed the word document.

I then went to my inbox, and nothing was listed in the sent list.
Please
help!!!!


:

I would suggest stating the steps you used to select your
recipient.
Include
your version and transport. Include everything else you did
differently
with
the second merge.
--
Russ Valentine
[MVP-Outlook]
I have an access database with info I want to email. I wrote a
mail
merge
document in word and everything went fine the first time. The
emails
ended
up
in my outlook send folder. I was happy.

Then I changed the query to email a different set of records. It
did
not
work. Any suggestions. Nothing appears in my sent folder. Any
suggestions
on
how to trouble shoot this?

 

[Brian Tillman]

So after all this the official answer from Microsoft is .... No my
yob!

Whatever gave you the idea that Russ works for Microsoft?

 

[Guest]

The truth is my frustration got to me. Russ is a nice person. A volunteer who
did his best. My frustration is that this is a Microsoft site, where we are
talking about 2 Microsoft Products run on a Microsoft operating systems which
can't communicate with one another.

And my boss is still asking me what i am going to do about this.

 

[Russ Valentine [MVP-Outlook]]

Mail merges are always frustrating to troubleshoot because they are
complicated, extremely poorly documented processes that involve more than
one application (and in your case, three).
All I can tell you is that your problem has never been reproduced to my
knowledge in Outlook, so we have nothing to go on here without more accurate
steps to repro. In my experience, if messages never even make it to Outlook,
the problem is upstream from Outlook, such as an email address that is not
resolved or recognized by your default transport type.
I also suspect there is more to your story than you may have recognized,
judging by your other post on this same subject.
Trust me, if anyone else had ever seen anything like this, they would have
jumped in this thread. Notice the silence? This is a subject where
cross-posting to Word and Access groups would make sense. I would have no
way of knowing the potential impact "changing your query" would have on your
Access database, for example, after you had already used this database
successfully for a merge.

 

[cturvin]

I am experiencing same problem. I used Outlook 2002 and the mail merge
wizard. I did all the steps, previewed the emails and completed the
mail merge. No of the recipients rec'vd an e-mail, but i didn't get an
error messages. My isp is earthlink dsl. Any ideas of what might be
happening?

Also, does it make sense to use an add-on for outlook such as
http://www.emailaddressmanager.com/mail_merge.html?
I am concerned that I will still not get the e-mails to go out.