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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Produce email reports in html with pictures linked and displayed

Status
Not open for further replies.
bluemat

bluemat

Technical User
Feb 5, 2002
61
MX
HI,

I think I put most of what I need in the subject title.

However basically I would like to be able to make reports with photos diplayed that are linked from an archive on a shared network drive.

Then send these html reports as emails (in HTML) displaying the linked photos.

It should be easy right?
 
Sort by date Sort by votes
I created a database to do that see (This is a small version of a Monster I created with Access, that catalogues hundreds of rolls of film for an Engineering projetc I worked on.
I do a directory *.jpg to file, import to Access then run a report that looks like this (all Access Labels, except the fields displayed, not Save As HTML)
(Hint CHR(34) is the double-quote needed to create the exact syntax)
Actually the <TR> lines are calculated for every x number of Printed details to make rows.
[Report Header of report design]
<HTML>
<BODY>
<TABLE WIDTH=600>
[Report Detail]
<TR>
<TD VALIGN=&quot;MIDDLE&quot; BGCOLOR=&quot;#00ffff&quot; HEIGHT=96><P ALIGN=&quot;CENTER&quot;>
<A HREF=&quot;bestdog.jpg&quot;>
<IMG SRC=&quot;bestdog.jpg&quot; BORDER=0 WIDTH=80 HEIGHT=80></A>
</TD>
</TR>
[Report footer]
</TABLE>
</BODY>
</HTML>

....
etc.
 
Upvote 0 Downvote
Thanks, it isn't quite what I want to do for this project, but it has given me an idea:)

Cheers
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

lmcate
  • Locked
  • Question
How to Open ACCESS (MDB) from an HTML Page 1
Replies
2
Views
4K
lmcate
lmcate
renigar
  • Locked
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
964
renigar
renigar
TheresAlwaysAWay
  • Locked
  • Question
Crazy question: Can anyone help me create a routine to roll 2 dice 1000x and sum them? 4
2
Replies
22
Views
6K
Andrzejek
Andrzejek
Bubba002
  • Locked
  • Question
WHERE clause in the Set command of an db.OpenRecordset method
Replies
16
Views
1K
dhookom
dhookom
TheresAlwaysAWay
  • Locked
  • Question
Can Access be used to generate and respond to text messages? 1
Replies
6
Views
5K
TheresAlwaysAWay
TheresAlwaysAWay

Part and Inventory Search

Sponsor

Back
Top