+ Reply to Thread
Results 1 to 1 of 1

automatically change text in automated e-mail from hyperlink

  1. #1
    Registered User
    Join Date
    06-17-2014
    Location
    norway
    MS-Off Ver
    2013
    Posts
    3

    automatically change text in automated e-mail from hyperlink

    Hi..

    I have the following excel file
    The random numbers are only reference numbers but they contain a hyperlink to a fixed e-mail adress with a fixed subject field.
    If I were to press the field with the number 17- then the e-mail looks like this:

    "Hi. Please send detailed info about your product 1953 model car together with color 1."

    So is there anyway to "auto.change" the text (the two variables) in the e-mail that my hyperlink generates? The two variables are the car model number (1952,1953,1954 etc.) snd the color1, color 2 etc...
    If I for example press the "77" in the 1955/color3 field, I want the e-mail to look like this intstead:

    "Hi. Please send detailed info about your product 1955 model car together with a color 3."

    Sorry my bad english and my even worse excel skills :-)



    car model number color 1 color 2 color 3 color 4 color 5 color 6

    1952 8- 1 5 6 6 9
    1953 17- 5 5 8 21 626
    1954 18- 4 2 8 25 62
    1955 8- 55 77 886 543 453
    1956 53 54 545 543 54 43345
    Attached Files Attached Files
    Last edited by worldwebber; 06-21-2014 at 09:21 PM. Reason: attachment

+ 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. How to change wording on and automated e-mail via Access
    By lurchybold in forum Access Tables & Databases
    Replies: 3
    Last Post: 08-15-2013, 05:15 PM
  2. Replies: 2
    Last Post: 07-12-2012, 08:11 PM
  3. Automated e-mail help
    By tubaguy63 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-07-2010, 03:45 AM
  4. Can excel automatically send e-mail when particular cell is change
    By ivica in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-20-2006, 05:55 PM
  5. Hyperlink - How to change default e-mail client?
    By Kamlesh in forum Excel General
    Replies: 4
    Last Post: 04-11-2006, 01:40 PM

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