+ Reply to Thread
Results 1 to 3 of 3

Text missing after & in email body

  1. #1
    Registered User
    Join Date
    12-09-2014
    Location
    Rotherham
    MS-Off Ver
    365
    Posts
    2

    Question Text missing after & in email body

    Hi

    I am creating a macro that follows a hyperlink (See below)

    Please Login or Register  to view this content.
    Folder Location - C:\products\Weights&Dimensions\

    The macro is designed to open a new email and in the body of the email have the location of the file, i.e
    Please Login or Register  to view this content.
    what is happening is the email is being opened and in the body all I am getting is,
    Please Login or Register  to view this content.
    .

    I am guessing it is to do with the
    Please Login or Register  to view this content.
    in the folder name, but I am trying to replace this but it isn't working.

    Any help would be great.

    Thanks

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

    Re: Text missing after & in email body

    HTML URL Encoding Reference

    Please Login or Register  to view this content.
    Last edited by AlphaFrog; 12-04-2019 at 06:21 PM.
    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
    12-09-2014
    Location
    Rotherham
    MS-Off Ver
    365
    Posts
    2

    Re: Text missing after & in email body

    Perfect. Thank you.

+ 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. [SOLVED] Generating Outlook Email and inseting chart into email with Text body.
    By Hyperion1571 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-17-2019, 12:41 PM
  2. [SOLVED] VBA to send email using data from the EXCEL including email address, subject and body text
    By ec4excel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-18-2016, 11:07 AM
  3. Replies: 0
    Last Post: 08-02-2016, 01:16 PM
  4. look for text in email body and move email to a folder
    By Megatronixs in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-10-2015, 05:23 AM
  5. [SOLVED] Emailing Sheet via Outlook by VBA - Body is Missing from 1st email only
    By DaveBre in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-05-2014, 11:53 PM
  6. [SOLVED] Text Box to Email Body
    By mattress58 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 09-25-2013, 02:04 PM
  7. Replies: 4
    Last Post: 02-27-2012, 03:13 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1