VBA Interfering with Email Addresses in Mail Merge?

  • Thread starter Grapevine
  • Start date Views 1,348
Status
Not open for further replies.
G

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

Grapevine
 
S

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.

Sue Mosher

"Grapevine" <grapevine> wrote in message

news:2696423B-9594-4549-B545-32C9462B9A04@microsoft.com...
> 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?
 
G

Grapevine

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

Grapevine

"Sue Mosher [MVP]" wrote:


> 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.
> > Sue Mosher
> > >

> "Grapevine" <grapevine> wrote in message
> news:2696423B-9594-4549-B545-32C9462B9A04@microsoft.com...
> > 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?


> .
>
 
Status
Not open for further replies.
Top