simora
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.
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.