+ Reply to Thread
Results 1 to 3 of 3

Excel Outlook Attachment Macro is attaching the Personal.XLSB and not the current file

  1. #1
    Registered User
    Join Date
    08-13-2009
    Location
    Glasgow
    MS-Off Ver
    Excel 2016,2016,365
    Posts
    92

    Excel Outlook Attachment Macro is attaching the Personal.XLSB and not the current file

    Hello,

    Please see code below. Can you help please with the following.
    1. Can I add a .From in the send macro as I want it to come from HRSS@companyname.com and not from my own personal company email address.
    2. When the email sends it attaching the Personal.XLSB file and not the spreadsheet that is open.

    I have attached the macros before I run the send one.
    Please Login or Register  to view this content.

    Thanks

    Ross
    Last edited by rosscortb; 07-05-2017 at 11:10 AM.

  2. #2
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: Excel Outlook Attachment Macro is attaching the Personal.XLSB and not the current file

    'ThisWorkbook' refers to the workbook hosting the code - 'ActiveWorkbook' refers to the workbook that is active on screen...

    Also:
    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

    The corect tags to use are [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE], not [HTML]

  3. #3
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: Excel Outlook Attachment Macro is attaching the Personal.XLSB and not the current file

    Thank you for the edit.

    This may help you to send using another account.

+ 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. Replies: 1
    Last Post: 03-14-2016, 12:41 PM
  2. [SOLVED] Personal.XLSB macro pasting into Personal.XLSB
    By davepoth in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-11-2015, 07:40 PM
  3. [SOLVED] Outlook Attachment - PDF file not attaching.
    By Maroota in forum Outlook Formatting & Functions
    Replies: 16
    Last Post: 05-01-2015, 06:57 AM
  4. Replies: 7
    Last Post: 03-30-2015, 05:51 PM
  5. Replies: 0
    Last Post: 01-15-2015, 05:53 AM
  6. [SOLVED] Run PERSONAL.XLSB macro when any Excel file is opened
    By Aaron092 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-23-2014, 04:35 AM
  7. Close Excel event to use with personal.xlsb file
    By richard.wilson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-09-2014, 05:28 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1