Hi,

Is it possible to browse and attach pictures to an email generated from Access XP VB?

I already produce the emails but would like the the attachment option.

Dave

That depends on the method you are using to generate the Emails. Can you post the code here for reference?

Hi ByteMyzer,

I use The DoCmd.SendObject command:

DoCmd.SendObject , , , strEmail, , , "Security Report " & Forms!IncidentView!IncNo & ":" & Forms!IncidentView!LogReport, Messagestr, False

strEmail is the recipient
IncNo & Forms!IncidentView!LogReport forms the Email subject
Messagestr is constructed from the records with added text.

Thanks

Only if you set the EditMessage option to True:

DoCmd.SendObject , , , _
strEmail, , , "Security Report " & Forms!IncidentView!IncNo _
& ":" & Forms!IncidentView!LogReport, Messagestr, True


Then you can browse and attach pictures to the Email.

Hi ByteMyzer,

So if the Editmessage option is true the email opens for editing...

I'll try that

Thanks very much for the help

Dave

Hi ByteMyzer,

Worked fine... thanks for the prompt response - much appreciated

Dave

If you want to automate it, you can attach other files using Outlook Automation instead of SendObject. Searching should turn up the code.