Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Thanks so much for your input on this. you are correct in saying that i've checked the actual temp jpgs between macros... i've checked them before, during (gotta love break mode), and after, and still the same result. however, i did notice a difference... i changed the filenames to a specified folder so they would no longer be in the temp folder using the "Environ$("temp")" command. now... i can access the jpgs just like before, but now the email is showing boxes with x's in them (as if the file does not exist). maybe i need to re-phrase how i've indicated where the file is? currently, i'm using: s1 = "<p<img src=file://" & Fname1 & "</p<br" where the Fname variable is directed to "C:\temp charts\tempchart1.jpg" and so on from there. so... maybe my syntax is just off with my html? i believe it would read (if the variable was written out..): "<p<img src=file://"C:\temp charts\tempchart1.jpg"</p<br" is this correct? i'm obviously still missing something... and knowing how things go... its probably really simple. :-) thanks again! -- Oh, the creative possibilities! ^_^ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using Macro how to create email link for the email addresses in aRange or Selection | Excel Worksheet Functions | |||
Excel VBA macro to send email attachment from default email client | Excel Programming | |||
email out Pivot Chart with one record only | Excel Programming | |||
email chart | Excel Programming | |||
Email a chart from excel via Lotus Notes | Excel Programming |