Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

link in email

Status
Not open for further replies.
gfrlaser1

gfrlaser1

Technical User
Jan 31, 2013
28
US
I currently have my email body written as:


oMsg.HTMLBody = [<html><font face = "Arial">];
+ [<font size = 2> <font color = 0><br>S:\Postal Documents<br><br>S:\Container Tags<br><br>Y:\Inkjet Files<br><br>W:\FS\MailDat <br><br>Maildate - &mdue<br><br>Quantity - &mquan<br></font></html>]
OMsg.Display()

What I want is for the "[highlight #3465A4]s:\postal Documents[/highlight]" to translate as a clickable link for the recipient in thier email. I have tried all variations of html code to make this possible but fail to find the right combination. Does anyone know the proper way to format this line?
 
Sort by date Sort by votes
Ok, Mike.

I tried now, and it works as you say. I never would have thought so, as TEXT..ENDTEXT has it's own clause.

So apologies, SET TEXTMERGE ON also solves the problem.

Bye, Olaf.
 
Upvote 0 Downvote
Works like a charm! Learned some interesting new things along the way. Again, thanks all!

[highlight #204A87]S:\postal Documents

S:\Container Tags

Y:\Inkjet Files

W:\FS\Maildat

Maildate - 12/16/13

Quantity - 2698[/highlight]
 
Upvote 0 Downvote
One more question if I may. One of my folder paths is: Y:\Digital Output Files\Working One-Off's\data. I am adding the final path as a variable <<mpre>>(for instance "\53698". When I hover over the final link in completed email,it looks perfect however, once I click the link it says "cannot find the file and you can clearly see an additional path of "digital" thrown in. It looks like Y:\DIGITAL\Digital Output Files\Working One-Off's\. The additional unwanted folder path of DIGITAL is all upper case if that is a clue. Where is that coming from?

This is the code that does not work.
example digidate = "53698"
store digidate to mpre

<a href="file://Y:\Digital%20Output%20Files\Working%20One-Off's\data\<<mpre>>">Y:\digital Output Files\Working One-Off's<<mpre>></a><br><br>
 
Upvote 0 Downvote
I can't see how that doubles the DIGITAL, give us the bigger scope of your code inside TEXT ENDTEXT.

One thing is for sure: Not only spaces need to be URL encoded. I'm sure the ' on Off's is problematic, too.
Lookup URL Encoding.

Bye, Olaf.
 
Upvote 0 Downvote
Thanks everyone, finally got it to work great thanks to your input.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

tom10
  • Locked
  • Question
Create eMail
Replies
8
Views
307
Chris Miller
Chris Miller
sdocker
  • Locked
  • Question
Email automation with OUTLOOKNEW
Replies
10
Views
497
Mike Lewis
Mike Lewis
dylim
  • Locked
  • Question
Send Email in VFP just using Windows native functions
Replies
4
Views
605
TamarGranor
TamarGranor
Ashwani Bansal
  • Locked
  • Question
Sending bulk email messages from VFP 6.0 and VFP 9
Replies
12
Views
1K
Dan Olsson
Dan Olsson
EinTerraner
  • Question
settings in config.fpw
Replies
12
Views
736
mplaza
mplaza

Part and Inventory Search

Sponsor

Back
Top