+ Reply to Thread
Results 1 to 3 of 3

Copy sheet on Desktop and email as attach new file created(with save/not "temp")

  1. #1
    Registered User
    Join Date
    05-30-2019
    Location
    Köln
    MS-Off Ver
    W10Pro
    Posts
    35

    Copy sheet on Desktop and email as attach new file created(with save/not "temp")

    HI all,

    please explain to me what is wrong with the code below which attaches an unusable file as an attachment .File2021.
    The first part works correctly, executes the copy in another workkbook, opens / displays it and saves it with the data name (file / sheet), after which it launches the Outlook application but the attachment is not the document on the desktop.
    Limitation is that the Desktop address must be dynamic (all users of the file have other usernames in C: / user /).
    Where am I wrong?
    Please Login or Register  to view this content.
    and how to set the Outlook application to have a signature in the body (not only plain text, normal view with images) ?

    I appreciate any help, thank you!

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

    Re: Copy sheet on Desktop and email as attach new file created(with save/not "temp")

    Try this...

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    05-30-2019
    Location
    Köln
    MS-Off Ver
    W10Pro
    Posts
    35

    Re: Copy sheet on Desktop and email as attach new file created(with save/not "temp")

    Like a charm!!!
    many thanks

+ 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. GetObject("C:\Temp\EXPORT.XLSX").Activate - save as
    By muss1210 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-06-2019, 05:16 AM
  2. [SOLVED] Macro for saving sheet as PDF to desktop and attach to email
    By Alan3770 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2018, 07:43 PM
  3. Using VBA to attach temp Excel sheet and email with Outlook
    By TBrophy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-17-2015, 04:50 PM
  4. Need Macro code to attach the words "FILE COPY" to second page only when printed?
    By ElmerFud in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-04-2014, 12:03 PM
  5. Need Macro code to attach the words "FILE COPY" to second page only when printed?
    By ElmerFud in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-04-2014, 10:21 AM
  6. [SOLVED] Code to save sheet as "PDF" to Desktop - Based on ComboBox 1 Value
    By matrixpom in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-21-2012, 04:37 AM
  7. Macro to File/Save as "Numbers as of [today's date]" on desktop
    By duugg in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-26-2009, 11:38 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