A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Outlook » Contacts
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Mail merge with email address



 
 
Thread Tools Display Modes
  #11  
Old September 2nd, 2008, 03:19 PM posted to microsoft.public.outlook.contacts
Diane Poremsky [MVP]
external usenet poster
 
Posts: 17,338
Default Mail merge with email address

No, its looking at a field labeled SMTP. It sounds as if the email address
field is not part of your data source. Or - the data has a field named SMTP
that is viewed as the first record.

--
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com

Outlook Tips by email:


EMO - a weekly newsletter about Outlook and Exchange:


You can access this newsgroup by visiting
http://www.microsoft.com/office/comm...s/default.mspx or point your
newsreader to msnews.microsoft.com.


"Budgie" wrote in message
...
From within Word 2007 having created master document and linked to Outlook
data source.

Select Mailings\Finish & Merge\

Dialog box title is: Check Names
Message is: Microsoft Office Outlook does not recognize "SMTP".
Sub mesage: Select the address to use:
Dialog option buttons: Show More Names, New Contact

Select Show More Names
The Address Book dialog is displayed with the Search Name Only radio
button
checked and "SMTP" in the Search field.

So Word is looking for a contact with the name SMTP rather than the
selected
contact or contacts! This apppears to be the problem?

Select any contact from the Address Book and the email is sent.

I want to send to 280 odd contacts. I will say that the Outlook file was
originally from Outlook 2000, some 6 months ago.

I get the same result, if I set filter to the current record, or a range
of
records, etc

Regards

Budgie

"Diane Poremsky [MVP]" wrote:

Does it really say
to supply contact details. Message reads Microsoft Office Outlook does
not
recognize "SMUT"


Or is is SMTP?

Can you send mail from outlook normally? Is the error message referring
to
your acct or the email addresses you are trying to merge?

--
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com

Outlook Tips by email:


EMO - a weekly newsletter about Outlook and Exchange:


You can access this newsgroup by visiting
http://www.microsoft.com/office/comm...s/default.mspx or point
your
newsreader to msnews.microsoft.com.


"Budgie" wrote in message
...
I am trying to run a mail merge from Outlook 2007 using a template
created
in
Word 2007. I have done this before, using Excel as a source and
Outlook
as a
source but am having problems now with Outlook.

When I test the merge - no errors. When I send the merge ouput to a
file -
no errors and 280 odd contacts appear in the merge file. When I run it
using
Outlook, selecting a limited number of records, I get a dialog box
asking
me
to supply contact details. Message reads Microsoft Office Outlook does
not
recognize "SMPT"

The data source is filtered, 3000 odd records down to 280 selected,
filtered
out for blank email addresses in an effort to mitigate error.

Any thoughts anyone?

Thanks in advance.

Martyn
"Russ Valentine [MVP-Outlook]" wrote:

Might want to clarify that a mail merge does not and cannot use a
Distribution List. OP will need to use another way to group Contacts
to
use
a mail merge.
Mail merges are always preferred over DL's.
--
Russ Valentine
[MVP-Outlook]
"Bons" wrote in message
...
Russ must have had on his "cranky pants" the day he replied!!
wowser...he
wasnt much help....I'll see if I can add some light to the
situation.
There
are a few different ways of accomplishing this.....You can create
distribution lists...for 250 I would create 3 or 4 lists, as most
email
handlers won't let you create supe large dl's.

You don't say what versions you have....but if it's at least 2003
you
can
do
a mail merge....after a few days of reading posts here I FINALLY
figured
this
one out....

From Contacts go up to Mail Merge-- at the bottom of the screen
choose
DOcument Type: Form Letters --- Merge To: Email and hit OK--This
will
take
you out to Word ---type up what ever you want---then hover along to
the
Mail
Merge Toolbar---down toward the right end---until you find Merge to
Email.
It
works like a charm! Hope this helps!!

"Peter" wrote:

How do I send an email in word to 250 distributors without having
to
click
each name in the address book?


  #12  
Old September 2nd, 2008, 03:29 PM posted to microsoft.public.outlook.contacts
Budgie
external usenet poster
 
Posts: 9
Default Mail merge with email address

OK using the Start Mail Merge\Email Messages option from within Word 2007.
Then the Select Recipients\Select from Outlook Contacts option to select the
data source
Then the Edit Recipient List option to filter/select the desired Outlook
Contacts, selecting on Company field = "The Target Company" and email Address
IS NOT BLANK (all displayed correctly), sorted by SaveAs field

The contacts are now in Outlook 2007, have been for 8 months. The data has
been migrated from Outlook 2000 to Outlook 2003 and is now to Outlook 2007.
The data has been created/updated over eight years, 3,500 contacts.

You say you should be doing this from within Outlook but this is
functionaility that is provided in Word 2007 and Word 2003. Why not do this
from Word?

How would you do this from within Outlook other than via Distribution Lists?

Regards

Budgie

"Russ Valentine [MVP-Outlook]" wrote:

It is still not clear from your description how you are filtering and
selecting your recipients nor how you "linked to an Outlook 2000 data
source." That would be the key information here and the most likely root of
your problem.
For this to work, your Outlook and Word versions must match and you should
be selecting your recipients in Outlook, then starting the merge in Outlook
to those selected recipients. Try that and see if it works.
--
Russ Valentine
[MVP-Outlook]
"Budgie" wrote in message
...
From within Word 2007 having created master document and linked to Outlook
data source.

Select Mailings\Finish & Merge\

Dialog box title is: Check Names
Message is: Microsoft Office Outlook does not recognize "SMTP".
Sub mesage: Select the address to use:
Dialog option buttons: Show More Names, New Contact

Select Show More Names
The Address Book dialog is displayed with the Search Name Only radio
button
checked and "SMTP" in the Search field.

So Word is looking for a contact with the name SMTP rather than the
selected
contact or contacts! This apppears to be the problem?

Select any contact from the Address Book and the email is sent.

I want to send to 280 odd contacts. I will say that the Outlook file was
originally from Outlook 2000, some 6 months ago.

I get the same result, if I set filter to the current record, or a range
of
records, etc

Regards

Budgie

"Diane Poremsky [MVP]" wrote:

Does it really say
to supply contact details. Message reads Microsoft Office Outlook does
not
recognize "SMUT"

Or is is SMTP?

Can you send mail from outlook normally? Is the error message referring
to
your acct or the email addresses you are trying to merge?

--
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com

Outlook Tips by email:


EMO - a weekly newsletter about Outlook and Exchange:


You can access this newsgroup by visiting
http://www.microsoft.com/office/comm...s/default.mspx or point
your
newsreader to msnews.microsoft.com.


"Budgie" wrote in message
...
I am trying to run a mail merge from Outlook 2007 using a template
created
in
Word 2007. I have done this before, using Excel as a source and
Outlook
as a
source but am having problems now with Outlook.

When I test the merge - no errors. When I send the merge ouput to a
file -
no errors and 280 odd contacts appear in the merge file. When I run it
using
Outlook, selecting a limited number of records, I get a dialog box
asking
me
to supply contact details. Message reads Microsoft Office Outlook does
not
recognize "SMPT"

The data source is filtered, 3000 odd records down to 280 selected,
filtered
out for blank email addresses in an effort to mitigate error.

Any thoughts anyone?

Thanks in advance.

Martyn
"Russ Valentine [MVP-Outlook]" wrote:

Might want to clarify that a mail merge does not and cannot use a
Distribution List. OP will need to use another way to group Contacts
to
use
a mail merge.
Mail merges are always preferred over DL's.
--
Russ Valentine
[MVP-Outlook]
"Bons" wrote in message
...
Russ must have had on his "cranky pants" the day he replied!!
wowser...he
wasnt much help....I'll see if I can add some light to the
situation.
There
are a few different ways of accomplishing this.....You can create
distribution lists...for 250 I would create 3 or 4 lists, as most
email
handlers won't let you create supe large dl's.

You don't say what versions you have....but if it's at least 2003
you
can
do
a mail merge....after a few days of reading posts here I FINALLY
figured
this
one out....

From Contacts go up to Mail Merge-- at the bottom of the screen
choose
DOcument Type: Form Letters --- Merge To: Email and hit OK--This
will
take
you out to Word ---type up what ever you want---then hover along to
the
Mail
Merge Toolbar---down toward the right end---until you find Merge to
Email.
It
works like a charm! Hope this helps!!

"Peter" wrote:

How do I send an email in word to 250 distributors without having
to
click
each name in the address book?



  #13  
Old September 2nd, 2008, 03:30 PM posted to microsoft.public.outlook.contacts
Diane Poremsky [MVP]
external usenet poster
 
Posts: 17,338
Default Mail merge with email address

BTW - was the outlook data source converted to a document or are you hitting
outlook each time? If a document, open it and view the data. Is the address
information correct? (If you are using a merge you saved previously, it may
be a document containing outlook data.)

When you get to the Finish & Merge, Merge to email dialog, it asks for the
email address field. I believe the default field name is Email_Address when
you use Outlook. You are apparently using one called SMTP and Outlook
doesn't recognize the contents of that field as email addresses.

Have you used the Match fields dialog to match the field names in the data
source with the ones word expects?

--
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com

Outlook Tips by email:


EMO - a weekly newsletter about Outlook and Exchange:


You can access this newsgroup by visiting
http://www.microsoft.com/office/comm...s/default.mspx or point your
newsreader to msnews.microsoft.com.


"Budgie" wrote in message
...
From within Word 2007 having created master document and linked to Outlook
data source.

Select Mailings\Finish & Merge\

Dialog box title is: Check Names
Message is: Microsoft Office Outlook does not recognize "SMTP".
Sub mesage: Select the address to use:
Dialog option buttons: Show More Names, New Contact

Select Show More Names
The Address Book dialog is displayed with the Search Name Only radio
button
checked and "SMTP" in the Search field.

So Word is looking for a contact with the name SMTP rather than the
selected
contact or contacts! This apppears to be the problem?

Select any contact from the Address Book and the email is sent.

I want to send to 280 odd contacts. I will say that the Outlook file was
originally from Outlook 2000, some 6 months ago.

I get the same result, if I set filter to the current record, or a range
of
records, etc

Regards

Budgie

"Diane Poremsky [MVP]" wrote:

Does it really say
to supply contact details. Message reads Microsoft Office Outlook does
not
recognize "SMUT"


Or is is SMTP?

Can you send mail from outlook normally? Is the error message referring
to
your acct or the email addresses you are trying to merge?

--
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com

Outlook Tips by email:


EMO - a weekly newsletter about Outlook and Exchange:


You can access this newsgroup by visiting
http://www.microsoft.com/office/comm...s/default.mspx or point
your
newsreader to msnews.microsoft.com.


"Budgie" wrote in message
...
I am trying to run a mail merge from Outlook 2007 using a template
created
in
Word 2007. I have done this before, using Excel as a source and
Outlook
as a
source but am having problems now with Outlook.

When I test the merge - no errors. When I send the merge ouput to a
file -
no errors and 280 odd contacts appear in the merge file. When I run it
using
Outlook, selecting a limited number of records, I get a dialog box
asking
me
to supply contact details. Message reads Microsoft Office Outlook does
not
recognize "SMPT"

The data source is filtered, 3000 odd records down to 280 selected,
filtered
out for blank email addresses in an effort to mitigate error.

Any thoughts anyone?

Thanks in advance.

Martyn
"Russ Valentine [MVP-Outlook]" wrote:

Might want to clarify that a mail merge does not and cannot use a
Distribution List. OP will need to use another way to group Contacts
to
use
a mail merge.
Mail merges are always preferred over DL's.
--
Russ Valentine
[MVP-Outlook]
"Bons" wrote in message
...
Russ must have had on his "cranky pants" the day he replied!!
wowser...he
wasnt much help....I'll see if I can add some light to the
situation.
There
are a few different ways of accomplishing this.....You can create
distribution lists...for 250 I would create 3 or 4 lists, as most
email
handlers won't let you create supe large dl's.

You don't say what versions you have....but if it's at least 2003
you
can
do
a mail merge....after a few days of reading posts here I FINALLY
figured
this
one out....

From Contacts go up to Mail Merge-- at the bottom of the screen
choose
DOcument Type: Form Letters --- Merge To: Email and hit OK--This
will
take
you out to Word ---type up what ever you want---then hover along to
the
Mail
Merge Toolbar---down toward the right end---until you find Merge to
Email.
It
works like a charm! Hope this helps!!

"Peter" wrote:

How do I send an email in word to 250 distributors without having
to
click
each name in the address book?


  #14  
Old September 2nd, 2008, 03:33 PM posted to microsoft.public.outlook.contacts
Diane Poremsky [MVP]
external usenet poster
 
Posts: 17,338
Default Mail merge with email address

The advantage of starting from Outlook is that you have much better
filtering capabilities. I don't think filtering is your problem though... I
think a field name is messed up. You might have the address type field
mapped as email address field - that would put SMTP into Word's address
field.

--
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com

Outlook Tips by email:


EMO - a weekly newsletter about Outlook and Exchange:


You can access this newsgroup by visiting
http://www.microsoft.com/office/comm...s/default.mspx or point your
newsreader to msnews.microsoft.com.


"Budgie" wrote in message
...
OK using the Start Mail Merge\Email Messages option from within Word 2007.
Then the Select Recipients\Select from Outlook Contacts option to select
the
data source
Then the Edit Recipient List option to filter/select the desired Outlook
Contacts, selecting on Company field = "The Target Company" and email
Address
IS NOT BLANK (all displayed correctly), sorted by SaveAs field

The contacts are now in Outlook 2007, have been for 8 months. The data
has
been migrated from Outlook 2000 to Outlook 2003 and is now to Outlook
2007.
The data has been created/updated over eight years, 3,500 contacts.

You say you should be doing this from within Outlook but this is
functionaility that is provided in Word 2007 and Word 2003. Why not do
this
from Word?

How would you do this from within Outlook other than via Distribution
Lists?

Regards

Budgie

"Russ Valentine [MVP-Outlook]" wrote:

It is still not clear from your description how you are filtering and
selecting your recipients nor how you "linked to an Outlook 2000 data
source." That would be the key information here and the most likely root
of
your problem.
For this to work, your Outlook and Word versions must match and you
should
be selecting your recipients in Outlook, then starting the merge in
Outlook
to those selected recipients. Try that and see if it works.
--
Russ Valentine
[MVP-Outlook]
"Budgie" wrote in message
...
From within Word 2007 having created master document and linked to
Outlook
data source.

Select Mailings\Finish & Merge\

Dialog box title is: Check Names
Message is: Microsoft Office Outlook does not recognize "SMTP".
Sub mesage: Select the address to use:
Dialog option buttons: Show More Names, New Contact

Select Show More Names
The Address Book dialog is displayed with the Search Name Only radio
button
checked and "SMTP" in the Search field.

So Word is looking for a contact with the name SMTP rather than the
selected
contact or contacts! This apppears to be the problem?

Select any contact from the Address Book and the email is sent.

I want to send to 280 odd contacts. I will say that the Outlook file
was
originally from Outlook 2000, some 6 months ago.

I get the same result, if I set filter to the current record, or a
range
of
records, etc

Regards

Budgie

"Diane Poremsky [MVP]" wrote:

Does it really say
to supply contact details. Message reads Microsoft Office Outlook
does
not
recognize "SMUT"

Or is is SMTP?

Can you send mail from outlook normally? Is the error message
referring
to
your acct or the email addresses you are trying to merge?

--
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com

Outlook Tips by email:


EMO - a weekly newsletter about Outlook and Exchange:


You can access this newsgroup by visiting
http://www.microsoft.com/office/comm...s/default.mspx or point
your
newsreader to msnews.microsoft.com.


"Budgie" wrote in message
...
I am trying to run a mail merge from Outlook 2007 using a template
created
in
Word 2007. I have done this before, using Excel as a source and
Outlook
as a
source but am having problems now with Outlook.

When I test the merge - no errors. When I send the merge ouput to a
file -
no errors and 280 odd contacts appear in the merge file. When I run
it
using
Outlook, selecting a limited number of records, I get a dialog box
asking
me
to supply contact details. Message reads Microsoft Office Outlook
does
not
recognize "SMPT"

The data source is filtered, 3000 odd records down to 280 selected,
filtered
out for blank email addresses in an effort to mitigate error.

Any thoughts anyone?

Thanks in advance.

Martyn
"Russ Valentine [MVP-Outlook]" wrote:

Might want to clarify that a mail merge does not and cannot use a
Distribution List. OP will need to use another way to group
Contacts
to
use
a mail merge.
Mail merges are always preferred over DL's.
--
Russ Valentine
[MVP-Outlook]
"Bons" wrote in message
...
Russ must have had on his "cranky pants" the day he replied!!
wowser...he
wasnt much help....I'll see if I can add some light to the
situation.
There
are a few different ways of accomplishing this.....You can create
distribution lists...for 250 I would create 3 or 4 lists, as most
email
handlers won't let you create supe large dl's.

You don't say what versions you have....but if it's at least 2003
you
can
do
a mail merge....after a few days of reading posts here I FINALLY
figured
this
one out....

From Contacts go up to Mail Merge-- at the bottom of the screen
choose
DOcument Type: Form Letters --- Merge To: Email and hit
OK--This
will
take
you out to Word ---type up what ever you want---then hover along
to
the
Mail
Merge Toolbar---down toward the right end---until you find Merge
to
Email.
It
works like a charm! Hope this helps!!

"Peter" wrote:

How do I send an email in word to 250 distributors without
having
to
click
each name in the address book?



  #15  
Old September 2nd, 2008, 04:47 PM posted to microsoft.public.outlook.contacts
Budgie
external usenet poster
 
Posts: 9
Default Mail merge with email address

You are spot on Diane. email Address is for some reason NOT mapped to email
Address in the Match Fields option despite the fact that this was set up
using the in built process linking Word and Outlook. The only other field
NOT correctly linked was Department.

BUT

when I checked that email Address was being picked up correctly by using
Insert Merge Field to add the email Address, this pulled in the correct data.
There must be a difference and an error in the way the Outlook links are set
up for these functions!

Thanks for your insight and assistance.

Budgie

"Diane Poremsky [MVP]" wrote:

The advantage of starting from Outlook is that you have much better
filtering capabilities. I don't think filtering is your problem though... I
think a field name is messed up. You might have the address type field
mapped as email address field - that would put SMTP into Word's address
field.

--
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com

Outlook Tips by email:


EMO - a weekly newsletter about Outlook and Exchange:


You can access this newsgroup by visiting
http://www.microsoft.com/office/comm...s/default.mspx or point your
newsreader to msnews.microsoft.com.


"Budgie" wrote in message
...
OK using the Start Mail Merge\Email Messages option from within Word 2007.
Then the Select Recipients\Select from Outlook Contacts option to select
the
data source
Then the Edit Recipient List option to filter/select the desired Outlook
Contacts, selecting on Company field = "The Target Company" and email
Address
IS NOT BLANK (all displayed correctly), sorted by SaveAs field

The contacts are now in Outlook 2007, have been for 8 months. The data
has
been migrated from Outlook 2000 to Outlook 2003 and is now to Outlook
2007.
The data has been created/updated over eight years, 3,500 contacts.

You say you should be doing this from within Outlook but this is
functionaility that is provided in Word 2007 and Word 2003. Why not do
this
from Word?

How would you do this from within Outlook other than via Distribution
Lists?

Regards

Budgie

"Russ Valentine [MVP-Outlook]" wrote:

It is still not clear from your description how you are filtering and
selecting your recipients nor how you "linked to an Outlook 2000 data
source." That would be the key information here and the most likely root
of
your problem.
For this to work, your Outlook and Word versions must match and you
should
be selecting your recipients in Outlook, then starting the merge in
Outlook
to those selected recipients. Try that and see if it works.
--
Russ Valentine
[MVP-Outlook]
"Budgie" wrote in message
...
From within Word 2007 having created master document and linked to
Outlook
data source.

Select Mailings\Finish & Merge\

Dialog box title is: Check Names
Message is: Microsoft Office Outlook does not recognize "SMTP".
Sub mesage: Select the address to use:
Dialog option buttons: Show More Names, New Contact

Select Show More Names
The Address Book dialog is displayed with the Search Name Only radio
button
checked and "SMTP" in the Search field.

So Word is looking for a contact with the name SMTP rather than the
selected
contact or contacts! This apppears to be the problem?

Select any contact from the Address Book and the email is sent.

I want to send to 280 odd contacts. I will say that the Outlook file
was
originally from Outlook 2000, some 6 months ago.

I get the same result, if I set filter to the current record, or a
range
of
records, etc

Regards

Budgie

"Diane Poremsky [MVP]" wrote:

Does it really say
to supply contact details. Message reads Microsoft Office Outlook
does
not
recognize "SMUT"

Or is is SMTP?

Can you send mail from outlook normally? Is the error message
referring
to
your acct or the email addresses you are trying to merge?

--
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com

Outlook Tips by email:


EMO - a weekly newsletter about Outlook and Exchange:


You can access this newsgroup by visiting
http://www.microsoft.com/office/comm...s/default.mspx or point
your
newsreader to msnews.microsoft.com.


"Budgie" wrote in message
...
I am trying to run a mail merge from Outlook 2007 using a template
created
in
Word 2007. I have done this before, using Excel as a source and
Outlook
as a
source but am having problems now with Outlook.

When I test the merge - no errors. When I send the merge ouput to a
file -
no errors and 280 odd contacts appear in the merge file. When I run
it
using
Outlook, selecting a limited number of records, I get a dialog box
asking
me
to supply contact details. Message reads Microsoft Office Outlook
does
not
recognize "SMPT"

The data source is filtered, 3000 odd records down to 280 selected,
filtered
out for blank email addresses in an effort to mitigate error.

Any thoughts anyone?

Thanks in advance.

Martyn
"Russ Valentine [MVP-Outlook]" wrote:

Might want to clarify that a mail merge does not and cannot use a
Distribution List. OP will need to use another way to group
Contacts
to
use
a mail merge.
Mail merges are always preferred over DL's.
--
Russ Valentine
[MVP-Outlook]
"Bons" wrote in message
...
Russ must have had on his "cranky pants" the day he replied!!
wowser...he
wasnt much help....I'll see if I can add some light to the
situation.
There
are a few different ways of accomplishing this.....You can create
distribution lists...for 250 I would create 3 or 4 lists, as most
email
handlers won't let you create supe large dl's.

You don't say what versions you have....but if it's at least 2003
you
can
do
a mail merge....after a few days of reading posts here I FINALLY
figured
this
one out....

From Contacts go up to Mail Merge-- at the bottom of the screen
choose
DOcument Type: Form Letters --- Merge To: Email and hit
OK--This
will
take
you out to Word ---type up what ever you want---then hover along
to
the
Mail
Merge Toolbar---down toward the right end---until you find Merge
to
Email.
It
works like a charm! Hope this helps!!

"Peter" wrote:

How do I send an email in word to 250 distributors without
having
to
click
each name in the address book?




  #16  
Old September 2nd, 2008, 08:32 PM posted to microsoft.public.outlook.contacts
Russ Valentine [MVP-Outlook]
external usenet poster
 
Posts: 9,440
Default Mail merge with email address

There is. When Outlook is your data source, a merge to email usually works
better when you start it from Outlook instead of Word because there seem to
be fewer opportunities to pick up the wrong address field for the
recipients. Also filtering and sorting of recipients seem to be more
reliable when you do them yourself in Outlook instead of using Word's merge
routine.
--
Russ Valentine
[MVP-Outlook]
"Budgie" wrote in message
...
You are spot on Diane. email Address is for some reason NOT mapped to
email
Address in the Match Fields option despite the fact that this was set up
using the in built process linking Word and Outlook. The only other field
NOT correctly linked was Department.

BUT

when I checked that email Address was being picked up correctly by using
Insert Merge Field to add the email Address, this pulled in the correct
data.
There must be a difference and an error in the way the Outlook links are
set
up for these functions!

Thanks for your insight and assistance.

Budgie

"Diane Poremsky [MVP]" wrote:

The advantage of starting from Outlook is that you have much better
filtering capabilities. I don't think filtering is your problem though...
I
think a field name is messed up. You might have the address type field
mapped as email address field - that would put SMTP into Word's address
field.

--
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com

Outlook Tips by email:


EMO - a weekly newsletter about Outlook and Exchange:


You can access this newsgroup by visiting
http://www.microsoft.com/office/comm...s/default.mspx or point
your
newsreader to msnews.microsoft.com.


"Budgie" wrote in message
...
OK using the Start Mail Merge\Email Messages option from within Word
2007.
Then the Select Recipients\Select from Outlook Contacts option to
select
the
data source
Then the Edit Recipient List option to filter/select the desired
Outlook
Contacts, selecting on Company field = "The Target Company" and email
Address
IS NOT BLANK (all displayed correctly), sorted by SaveAs field

The contacts are now in Outlook 2007, have been for 8 months. The data
has
been migrated from Outlook 2000 to Outlook 2003 and is now to Outlook
2007.
The data has been created/updated over eight years, 3,500 contacts.

You say you should be doing this from within Outlook but this is
functionaility that is provided in Word 2007 and Word 2003. Why not do
this
from Word?

How would you do this from within Outlook other than via Distribution
Lists?

Regards

Budgie

"Russ Valentine [MVP-Outlook]" wrote:

It is still not clear from your description how you are filtering and
selecting your recipients nor how you "linked to an Outlook 2000 data
source." That would be the key information here and the most likely
root
of
your problem.
For this to work, your Outlook and Word versions must match and you
should
be selecting your recipients in Outlook, then starting the merge in
Outlook
to those selected recipients. Try that and see if it works.
--
Russ Valentine
[MVP-Outlook]
"Budgie" wrote in message
...
From within Word 2007 having created master document and linked to
Outlook
data source.

Select Mailings\Finish & Merge\

Dialog box title is: Check Names
Message is: Microsoft Office Outlook does not recognize "SMTP".
Sub mesage: Select the address to use:
Dialog option buttons: Show More Names, New Contact

Select Show More Names
The Address Book dialog is displayed with the Search Name Only radio
button
checked and "SMTP" in the Search field.

So Word is looking for a contact with the name SMTP rather than the
selected
contact or contacts! This apppears to be the problem?

Select any contact from the Address Book and the email is sent.

I want to send to 280 odd contacts. I will say that the Outlook
file
was
originally from Outlook 2000, some 6 months ago.

I get the same result, if I set filter to the current record, or a
range
of
records, etc

Regards

Budgie

"Diane Poremsky [MVP]" wrote:

Does it really say
to supply contact details. Message reads Microsoft Office
Outlook
does
not
recognize "SMUT"

Or is is SMTP?

Can you send mail from outlook normally? Is the error message
referring
to
your acct or the email addresses you are trying to merge?

--
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com

Outlook Tips by email:


EMO - a weekly newsletter about Outlook and Exchange:


You can access this newsgroup by visiting
http://www.microsoft.com/office/comm...s/default.mspx or
point
your
newsreader to msnews.microsoft.com.


"Budgie" wrote in message
...
I am trying to run a mail merge from Outlook 2007 using a
template
created
in
Word 2007. I have done this before, using Excel as a source and
Outlook
as a
source but am having problems now with Outlook.

When I test the merge - no errors. When I send the merge ouput
to a
file -
no errors and 280 odd contacts appear in the merge file. When I
run
it
using
Outlook, selecting a limited number of records, I get a dialog
box
asking
me
to supply contact details. Message reads Microsoft Office
Outlook
does
not
recognize "SMPT"

The data source is filtered, 3000 odd records down to 280
selected,
filtered
out for blank email addresses in an effort to mitigate error.

Any thoughts anyone?

Thanks in advance.

Martyn
"Russ Valentine [MVP-Outlook]" wrote:

Might want to clarify that a mail merge does not and cannot use
a
Distribution List. OP will need to use another way to group
Contacts
to
use
a mail merge.
Mail merges are always preferred over DL's.
--
Russ Valentine
[MVP-Outlook]
"Bons" wrote in message
...
Russ must have had on his "cranky pants" the day he replied!!
wowser...he
wasnt much help....I'll see if I can add some light to the
situation.
There
are a few different ways of accomplishing this.....You can
create
distribution lists...for 250 I would create 3 or 4 lists, as
most
email
handlers won't let you create supe large dl's.

You don't say what versions you have....but if it's at least
2003
you
can
do
a mail merge....after a few days of reading posts here I
FINALLY
figured
this
one out....

From Contacts go up to Mail Merge-- at the bottom of the
screen
choose
DOcument Type: Form Letters --- Merge To: Email and hit
OK--This
will
take
you out to Word ---type up what ever you want---then hover
along
to
the
Mail
Merge Toolbar---down toward the right end---until you find
Merge
to
Email.
It
works like a charm! Hope this helps!!

"Peter" wrote:

How do I send an email in word to 250 distributors without
having
to
click
each name in the address book?





 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:43 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.