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:
> dailytips-subscribe-request@
lists.outlooktips.net
>
> EMO - a weekly newsletter about Outlook and Exchange:
> EMO-NEWSLETTER-SUBSCRIBE-REQUEST@
PEACH.EASE.LSOFT.COM
>
> You can access this newsgroup by visiting
>
http://www.microsoft.com/office/community/en-us/default.mspx or point your
> newsreader to
msnews.microsoft.com.
>
>
> "Budgie"
discussions.microsoft.com> wrote in message
> news:872672F1-986E-4C3B-912C-AC28BF121B44@microsoft.com...
>> 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"
discussions.microsoft.com> wrote in message
>>> news:7CA3D7E2-4E57-4DB6-B2BF-7C6A0FE4F2EF@microsoft.com...
>>>> 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: ,
>>>>
>>>> Select
>>>> 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"
>>>>>> 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"
discussions.microsoft.com> wrote in message
>>>>>>> news:8498CA70-E682-4F39-9B48-8F83AF284BC6@microsoft.com...
>>>>>>>> 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?
>>>>>>>
>>>>>
>>>
>