+ Reply to Thread
Results 1 to 7 of 7

Send mails with attachment

  1. #1
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    Send mails with attachment

    Hi friends,

    Greetings from me!

    I want to send wishing mails on birthday and holiday with attachment store in ‘OUTPUT’ folder.
    The file name should not contain a period so the file name should be as in column ‘N’ ‘FILE NAME’ without a title.
    The name in the message body should be as in column ‘O’ ‘NAME’ having a title.

    Now the problem is:

    For birthday:
    The macro finishes without sending mails.

    For holiday:
    The mails are creating but the attachment is not attaching.

    Any help will be highly appreciated.

    Thanking you in anticipation.
    Attached Files Attached Files
    Sincerely,

    mso3

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Help request to send mails with attachment

    Hello mso#,

    You are using the wrong index for the date.

    Make this change to your For loop...
    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    Re: Help request to send mails with attachment

    Hello Leith Ross,
    Thank you. The birthday mail problem is solved but what is a error in holiday macro? The holiday mails are creating but the attachment is not attached. The attachment should match the name in 'column N' because the file name is without title.

    Thank you.

  4. #4
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    Re: Help request to send mails with attachment

    Hello Leith Ross,

    Greetings from me!

    Please see the following code and suggest me the correction to attach attachment to the mail. The first problem of birthday mail is solved.

    Please Login or Register  to view this content.
    Sorry for trouble.

    Thanking you in anticipation.

  5. #5
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Send mails with attachment

    Hello mso3,

    I made a few changes to your "Holiday" macro and tested it. It attached files for me with no problems.

    Please Login or Register  to view this content.

  6. #6
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    Re: Send mails with attachment

    Hi Leith Ross,

    Greetings from me!

    To solve the problem I have a new idea as follows:

    I have deleted the column ‘NAME’
    Now the attachment is attaching to the mail. So our file attach problem is solved.
    To insert a title in between salutation and the name we should insert it inn between after attaching the attachment. So that our name and file name matching problem will be solved and the file will attach to the mail.
    After attaching the file we should insert the title ‘column C’ in between the salutation and the name in both programs namely Birthday and Holiday positively.
    With this amendment our problem will be solved today definitely.

    I request you to do this amendment today positively to complete the program.

    Sorry for trouble.

    Waiting to receive a solution today eagerly.

    Thanking you in anticipation.
    Attached Files Attached Files
    Last edited by mso3; 11-12-2015 at 01:12 PM.

  7. #7
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    Re: Send mails with attachment

    Hi Leith Ross,
    Thank you. The problem is solved.

    I appreciate you for your kind cooperation to solve the problem.

    Thank you and have a nice day.
    Last edited by mso3; 11-13-2015 at 05:58 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Unable to send mails problem
    By mso3 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-22-2015, 09:32 PM
  2. Multiple mails with attachment from outlook
    By annupojupradeep in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 07-27-2015, 10:03 AM
  3. How to Send automated mails with attachment files saved in a folder?
    By yemnirmal in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-20-2014, 03:16 PM
  4. How to email Powerpoint attachment with a list of e-mails in excel file
    By yseto in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-11-2014, 05:15 AM
  5. Code to send an e-mail. Don't send if attachment not found
    By thedon_1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-24-2012, 05:41 PM
  6. [SOLVED] My send to in excel/word does not offer send as attachment
    By Mstink in forum Excel General
    Replies: 11
    Last Post: 03-16-2006, 10:55 AM
  7. [SOLVED] i am not getting any e mails when clicking rec/send how do i re
    By maxysaxy in forum Excel General
    Replies: 1
    Last Post: 12-30-2005, 12:15 PM

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