ACCESS - Email current form

[Sherip46]

Hello

I am looking for help in creating a VBA Code that will email the current form as an attachment.

I have the command button created that will open outlook, input the subject, and body message. But I would like the form for the record I have active to be included as an attachment in the email - not all the forms.

Is that possible?

TIA

Sheri

[alansidman]

Look at this link

http://www.access-programmers.co.uk/...ad.php?t=49076

[Sherip46]

Thank you @alansidman

Although, I did find this code:
From: http://www.access-programmers.co.uk/...d.php?t=240551

Please Login or Register  to view this content.

I am just trying to make it work for the form I have. I do not have an invoice #, but there is a file number, and I assume the "Invoice" would be the form name. Still trying to break this apart, but a little difficult when you can't see the actual database.

[alansidman]

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html


(Because you are new to the forum, I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

[Sherip46]

Thank you, I will read up on them today.

[alansidman]

Did you read the link I sent you? Did you try it out? You have provided new code unrelated with no means to compare what the fields are and how they compare to your db. Suggest you upload your file scrubbed for confidential data. Probably only need your table and the bound form you are trying to export. Make sure that there are only a few records or it will be bloated and will not load. Additionally, after scrubbing, run a compact and repair and then zip the file in order to upload to this site. Click on Go Advanced and scroll down to manage attachments.

[Sherip46]

Here is a sample copy of the database I am trying to work with.

Hopefully I have done this correctly

[alansidman]

Ok Sheri, I think I've got it. If you are using 2007, then use the instructions in this link.

http://www.techrepublic.com/blog/mic...d-access-form/

I am using 2013, so on the ribbon with the selected record open on the form, click on External--->Export--->Email--->HTML

Because I don't use Outlook, I wasn't able to test any further. When I selected, it did bring up an Outlook Email and displayed the attachment as an HTML document. I was not aware of this feature in Access. Thanks for asking and helping me also.

[Sherip46]

Thank you this might be okay - I would prefer if it looked more like the form rather than the attached image (there are a lot of blank/ false fields that would show a check mark on the form - this method does not reveal that information).

I have read where there is the possibility of having a command button first convert the form into a PDF and then attach to an email.

I also tried to use the "email selection as PDF" from the ribbon on the External Data tab - but even though "Only Selection" is selected, it still includes ALL the forms.

[Sherip46]

I believe I may have found a solution to execute my needs.

If I apply a filter to the forms so that only one record is visible - I can then use the 'Email' command (and select PDF option in the dialog box)on the ribbon under the 'External Data' tab. If there is only one record showing, it will attach that record as a PDF.

Thank you for all your help

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.