+ Reply to Thread
Results 1 to 5 of 5

Error in mailing of a file as attachment in my selected folder path

  1. 12-29-2017, 07:10 AM #1
    Vcare
    Vcare is offline
    Registered User
    Join Date
    11-29-2016
    Location
    India
    MS-Off Ver
    2010 2007
    Posts
    59

    Error in mailing of a file as attachment in my selected folder path

    Hi,

    I got stuck in a small error while processing & sending pdf file.

    I'm getting an error in a vba process where i have mail a particular file which will be saved in a particular folder and the same has to be get attached to mail & then send.

    Code is something like this.
    Please Login or Register  to view this content.
    Please help on this.
    Reply With QuoteRegister To Reply
  2. 12-29-2017, 07:14 AM #2
    than_gold
    than_gold is offline
    Valued Forum Contributor than_gold's Avatar
    Join Date
    10-17-2017
    Location
    Coimbatore India
    MS-Off Ver
    Office 365
    Posts
    646

    Re: Error in mailing of a file as attachment in my selected folder path

    Hello,
    Please provide whole code, with this partial code, difficult to figure out.
    what is mentioned in MyPath ???
    Regards,
    Thangavel D
    Appreciate the help? CLICK *
    Reply With QuoteRegister To Reply
  3. 12-29-2017, 07:25 AM #3
    Vcare
    Vcare is offline
    Registered User
    Join Date
    11-29-2016
    Location
    India
    MS-Off Ver
    2010 2007
    Posts
    59

    Re: Error in mailing of a file as attachment in my selected folder path

    Here is the complete code.

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 12-29-2017, 07:28 AM #4
    than_gold
    than_gold is offline
    Valued Forum Contributor than_gold's Avatar
    Join Date
    10-17-2017
    Location
    Coimbatore India
    MS-Off Ver
    Office 365
    Posts
    646

    Re: Error in mailing of a file as attachment in my selected folder path

    MyPath is not defined,
    Please use Debug -> Compile VBA project. this will identify the non defined variables.
    Please put the screenshot of the error as well.
    Reply With QuoteRegister To Reply
  5. 12-29-2017, 07:33 AM #5
    Vcare
    Vcare is offline
    Registered User
    Join Date
    11-29-2016
    Location
    India
    MS-Off Ver
    2010 2007
    Posts
    59

    Re: Error in mailing of a file as attachment in my selected folder path

    Run Time Error 13 Type mismatch.

    In this actually i'll be selecting a folder mannually to save the created .pdf files.
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [Path location and Document macro]Require File , Folder and sub-folder path creator macro
    By Nitish Shrestha in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-17-2017, 02:23 AM
  2. VBA code excel list of folder name, the folder path of subfolder, the file name & revision
    By klpw in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-29-2015, 04:19 AM
  3. Choosing folder path (instead of file path) in VBA
    By sminter in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-23-2014, 08:50 PM
  4. Code to list the folder path and sub folder path of a specific file
    By kalai1587 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-13-2013, 03:51 AM
  5. [SOLVED] Save As Dialog Box - Default Path and File Name, User Selects Sub Folder from Default Path
    By christenprochaska in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-12-2012, 05:17 PM
  6. Specified folder path to select file path
    By JayEmTee91 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-29-2012, 10:38 AM
  7. [SOLVED] mailing whole excel file as an attachment.
    By CJ in forum Excel General
    Replies: 1
    Last Post: 04-13-2005, 11:06 AM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1