+ Reply to Thread
Results 1 to 2 of 2

Problem with adding attachment to e-mail

  1. #1
    Registered User
    Join Date
    11-04-2013
    Location
    Budapest
    MS-Off Ver
    Excel 2010
    Posts
    2

    Problem with adding attachment to e-mail

    Hi All,

    I am creating a macro to export several sheets into pdf's which are then saved on the desktop. The next step is that i want to send each attachment to a different recipient.

    While doing this i get a object not found error.

    I have no idea how to refer to the PDF file which has a file name created from a combination of values out of different cells in yet another sheet.

    Please Login or Register  to view this content.
    Any help is very much appreciated.

    Thanks,
    Steve

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Problem with adding attachment to e-mail

    Steve

    Replace commandeur.pdf with the path and filename of the pdf you want to attach.

    Off the top of my head that will be this.
    Please Login or Register  to view this content.
    Or if you need the file extension.
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

+ 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. Mail Range/Selection in the body of the mail along with an attachment
    By johnny_canuck in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-27-2013, 05:52 AM
  2. Creating an e-mail with an e-mail attachment
    By Peter1245 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-25-2013, 03:42 AM
  3. code to attach the draft mail in new compose mail as attachment in outlook 2010
    By priya1987 in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 10-10-2012, 08:38 AM
  4. Problem in mail attachment when using CDO
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-21-2006, 04:45 AM
  5. e mail attachment
    By zapatista66 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-18-2005, 10:16 AM

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