+ Reply to Thread
Results 1 to 3 of 3

Email send 2 attachments instead of 1

  1. #1
    Forum Contributor unley's Avatar
    Join Date
    11-27-2008
    Location
    South Australia
    MS-Off Ver
    MS Office 2007
    Posts
    253

    Email send 2 attachments instead of 1

    Giday to you all

    I was trying to manupilate the codes that I found on the internet where I can attach a sheet to email in Outlook but I want to display the email before sending so that I can change the email address from time to time instead of me have to go back to VBA windows and keep changing email address in the codes.

    I'm about 90% successful but the email send 2 same attachments instead of 1.

    Please Login or Register  to view this content.
    The email in the codes is not my actual email address for security purpose.

    I'm sure there is only a minor configuration to do

    Thanks so much inadvance

    Last edited by unley; 01-23-2013 at 01:51 AM.
    I'm using MS Office 2013

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,651

    Re: Email send 2 attachments instead of 1

    You have this line of code twice and you only need it once.

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor unley's Avatar
    Join Date
    11-27-2008
    Location
    South Australia
    MS-Off Ver
    MS Office 2007
    Posts
    253

    Re: Email send 2 attachments instead of 1

    Thanks for such a quick replay AlphaFrog

    Oh silly me must have copied the code twice in a hurry

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1