Solved Attache files from main form to Outlook (1 Viewer)

[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.

 

[theinviter]

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

2019

 

[theinviter]

thanks a lot teams, really appreciated your kind support.

 

[theinviter]

here test your db.

HI:
what if i want to place the button in Report and upon click do the same for attachment (attach to email) how to do it?

 

[theDBguy]

HI:
what if i want to place the button in Report and upon click do the same for attachment (attach to email) how to do it?

Reports are usually used for printing, so the button won't work when printed or in print preview. It could work only in Report View.

 

[theinviter]

Reports are usually used for printing, so the button won't work when printed or in print preview. It could work only in Report View.

Yes its in report view but when copied the code got error: " Syntax error" If Me.Recordset.Fields(Me.Sigend_Form.AttachmentCount > 0 Then

 

[theinviter]

Reports are usually used for printing, so the button won't work when printed or in print preview. It could work only in Report View.

can you please help for attached file.

 

[June7]

Where is that code supposed to be? I don't find it in posted db. Code makes no sense anyway.



Should Sigend_Form really be spelled Signed_Form?