Email Merge

[Gene Augustin]

MAC Powerbook G4, OS 10.5.6
Office 2004, Excel 2004 Version 11.5.3
Acrobat Pro 9.1

I am using the intellimerge demo. It is ok, but puts the desired information
in an attachment instead of the main document. There is a way in
intellimerge to use a web link to do it, but I haven't tried it yet.

I thought I saw somewhere that there is an email merge macro for excel, but
I can't find it.

Gene

 

[Mike Middleton]

Gene -

Excel guru Ron de Bruin has VBA code for sending mail from Windows Excel,
and maybe you could adapt his code for your situation.

On his web site, see the "Excel Add-ins and code for Mailing from Excel"
section of his Tips page at http://www.rondebruin.nl/tips.htm

Specifically, see "Example Code for sending mail from Excel" at
http://www.rondebruin.nl/sendmail.htm

- Mike

http://www.MikeMiddleton.com