Word merge to e-mail using excel data

[petebsmith]

Hi,
I do this all the time with my windows pc at work but its the first
time I've tried it from my mac. I've written a mail merge document in
word and picked up merge fields from an excel document. Proof of the
merge looks fine but when I go to the button for merge to e-mail in the
merge manager, the button is still greyed out, all the manager will do
is merge to printer or to a new document. I've searched the news group
for a similar problem and didn't find it, my apologies if this has come
up before! By the way, I've set up entourage on my mac to send and
receive and it does fine with single e-mails. I went into entourage to
set it as my default e-mail and that seems to have happened as well.
Still no change on the merge to e-mail button in the merge manager!
Thanks, Pete

 

[Daiya Mitchell]

Most important question: what version of Office, what version OS, what
updates applied?

I've made this work with Office 2004, no problem. The only obviously
questionable thing I see you doing is

I went into entourage to
set it as my default e-mail and that seems to have happened as well.

When I think the default email program setting is in Mail's Preferences, if
you ever set up Mail. That may be it.

 

[petebsmith]

Hi,
I'm using office x, wordx service release 1. System 10.3.9.
Just tried changing default e-mail setting in mail to entourage. Now
the icon in the Word x merge document manager works!
Thanks!!
Pete

 

[Jim Gordon MVP]

Hi,

In order for the email button to work there must be a field that has
email addresses and you have to put that field somewhere in the body of
the document you wish to send.

Try changing the name of the column that has email addresses to Email,
and then use that field somewhere in the body of the Word document.

If you don't want the email address to display, then select the email
field and use Format>Font from Word's menu. Then check the Hidden option.

-Jim