View Full Version : Sending emails with attachments from excel

08-26-2013, 09:40 PM
I have a worksheet with 8 used columns A - H ( Office 2003 & Win XP )
The columns that I want to use are;

Column A - Salutation
Column B - Last Name
Column D - eMail Address
Cell H1 is the Subject

I'm trying to get a VBA macro to email everyone in Column D a copy of an attachment.
The attachment is a .doc file sitting on my desktop . ( I can put it into a folder if needed )

When I run the macro, Outlook tells me that it doesn't recognize one or more names.

How can I have the body of the email say " Dear < Salutation> . <Lastname> Please see attached document "

And have the attachment sent to everyone in Column D.

Attached is the worksheet I'm using.

08-27-2013, 10:34 AM
I'm not sure this was the correct place for this, and as I got no responses, I re-posted it in the Outlook forum here


If you have suggestions or solutions, I still need this resolved.