VBA Interfering with Email Addresses in Mail Merge?

[Grapevine]

Hi

I am using Doug Robbins' MVP email merge with attachments solution for
Outlook using VBA.

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

All works fine unitl the actual merge to the addresses where Outlook seems
to be interfering and entering email addresses for some of the contacts
rather than using the addresses specified in Dougs' solution. Not sure but it
seems like the addressesit's picking on are for people for whom I hal;ready
have contact data in Outlook. Problem is, there is often a mismatrch of email
data between Outlook and speciifed list for merge-home vs work, outdated etc.

Can you override Outlook input in this regard somehow?

Matt

 

[Sue Mosher [MVP]]

As this problem seems to be specific to your data, I'd suggest that you
focus your attention there. In other words, what are the actual values
you're seeing for Datarange when it's used to set the value of the To
property? I suspect that will reveal what the problem might be.

 

[Grapevine]

Thanks Sue, will check this out - once I've figured out what it means!