Attach Picture to automated email

[Dave Eyley]

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

 

[ByteMyzer]

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

 

[Dave Eyley]

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

 

[ByteMyzer]

Only if you set the EditMessage option to True:

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

Then you can browse and attach pictures to the Email.

 

[Dave Eyley]

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

 

[Dave Eyley]

Hi ByteMyzer,

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

Dave

 

[pbaldy]

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