Attache files from main form to Outlook

[theinviter]

Dears:
Kind support.
is there a way to attach the Form present in main form from current record to outlook on button click.
as I want upon button click any attached files in current record go to outlook email.
File attached, kind support on how to do this.

 

[Mark_]

Before providing any advice, which version of Outlook are you using? Outlook Classic is different than the New outlook.

 

[theDBguy]

Can't look at your file right now, but are you really trying to attach a Form to an email, or are we talking about files in an attachment field?

 

[June7]

Yes, this is about an Attachment type field.
This is a common topic.
Attaching file from Attachment field to an email requires first extracting file to folder location then attaching to email using Outlook automation. You already have Outlook code so now incorporate following https://learn.microsoft.com/en-us/o...tabase-reference/field2-savetofile-method-dao along with objMail.Attachments.Add method https://stackoverflow.com/questions/26184217/attach-multiple-files-or-entire-directory-to-email. Code can then delete entire folder or files from folder with Kill method.

Really need to give buttons meaningful names instead of keeping names assigned by Access.

 

[arnelgp]

here test your db.