How do I send a file by email via VBA?

H

hanski

Hi.

I have a table where is two columns called Car and Photo. In Car I
have a name of a car, for instace Ford,Renault etc. In Photo I have a
hyberlink to a file, where is jpg-file from that car.

When I choose, in my form, for instace Ford, so I would like to send
that jpg-file from Ford by email to someone automatically. Is it
possible?


hanski
 
T

Tom van Stiphout

On Mon, 15 Sep 2008 05:18:03 -0700 (PDT), hanski

You could create a report and then use:
docmd.SendObject acSendReport
to email it.

-Tom.
Microsoft Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word VBA - Automatic change content of a cell in table using dropdown list 5
Mail Merge file containing a Word Table 0
You'll need a new app to open this about link 1
Merging from an Excel file with graphics 1
Change the "From" email address VBA 0
Insert multiple objects at once ? 3
Multiple lines from different tables in a report detail 3
How can I get a Shareable URL via VBA code to a OneDrive image? 0

Top