View Single Post
  #2  
Old May 6th, 2010, 10:14 PM posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
Default Programming for Outlook "Check Names"

Are you actually automating Outlook of just the mailmerge? I think that if
you use code such as that in the article "Mail Merge to E-mail with
Attachments" at:

http://word.mvps.org/FAQs/MailMerge/...ttachments.htm

errors in email addresses will be ignored, or you could use On Error Resume
Next before the .Send command.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"Diane" wrote in message
...
Group,
Using OFFICE 2007

Within MSWORD, I created a vba script that completes a mail merge using
Excel as the data source. All works well, until there is an invalid email
address, such as missing "@", or missing ".net, .org, etc...

I realize now this error is actually coming from Outlook as it is sending
the email, I've turned off the option for "check names" from
Outlook/tools/options/email/advance, although this does not stop the error
from haulting the mail merge process. Since this mail merge/email process
completes during off-time hours, it is necessary that I am able to prevent
this error. Is it possible to intercept an Outlook error during a MS WORD
mail merge process.

Thanks,