Consulting

Results 1 to 2 of 2

Thread: Sending emails with attachments from excel

  1. #1
    VBAX Mentor
    Joined
    Jan 2008
    Posts
    347
    Location

    Sending emails with attachments from excel

    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.
    Attached Files Attached Files

  2. #2
    VBAX Mentor
    Joined
    Jan 2008
    Posts
    347
    Location
    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

    http://www.vbaexpress.com/forum/show...ed-attachments

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

    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •