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?

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]
"zombeese" wrote in message
...
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?

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


"Russ Valentine [MVP-Outlook]" wrote:

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]
"zombeese" wrote in message
...
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?

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.

"zombeese" wrote:

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?

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]
"zombeese" wrote in message
...
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!!!!


"Russ Valentine [MVP-Outlook]" wrote:

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]
"zombeese" wrote in message
...
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?

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.


"Russ Valentine [MVP-Outlook]" wrote:

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]
"zombeese" wrote in message
...
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!!!!


"Russ Valentine [MVP-Outlook]" wrote:

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]
"zombeese" wrote in message
...
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?

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]
"zombeese" wrote in message
...
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.


"Russ Valentine [MVP-Outlook]" wrote:

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]
"zombeese" wrote in message
...
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!!!!


"Russ Valentine [MVP-Outlook]" wrote:

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]
"zombeese" wrote in message
...
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?

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

"Russ Valentine [MVP-Outlook]" wrote:

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]
"zombeese" wrote in message
...
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.


"Russ Valentine [MVP-Outlook]" wrote:

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]
"zombeese" wrote in message
...
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!!!!


"Russ Valentine [MVP-Outlook]" wrote:

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]
"zombeese" wrote in message
...
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?

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]
"zombeese" wrote in message
...
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!!!!!!!

"Russ Valentine [MVP-Outlook]" wrote:

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]
"zombeese" wrote in message
...
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.


"Russ Valentine [MVP-Outlook]" wrote:

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]
"zombeese" wrote in message
...
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!!!!


"Russ Valentine [MVP-Outlook]" wrote:

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]
"zombeese" wrote in message
...
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?

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

"Russ Valentine [MVP-Outlook]" wrote:

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]
"zombeese" wrote in message
...
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!!!!!!!

"Russ Valentine [MVP-Outlook]" wrote:

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]
"zombeese" wrote in message
...
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.


"Russ Valentine [MVP-Outlook]" wrote:

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]
"zombeese" wrote in message
...
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!!!!


"Russ Valentine [MVP-Outlook]" wrote:

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]
"zombeese" wrote in message
...
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?