473,322 Members | 1,690 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

How To Send Screen.ActiveForm to Email

I Use Win 7 Office 2010 Access
I wrote the program many years ago, am now 76 and having trouble remembering step 1 by the time I get to step 3.
I print my invoices, and would like a button with code on invoice page to send Screen.ActiveForm to Email1 on the form.

If it easy I would like to also save a copy to my computer to save on paper with seperate button
Thank you
ted
Dec 24 '12 #1
2 2216
zmbd
5,501 Expert Mod 4TB
Ted,
If your forms or reports are already formatted to print out in the manner you desire, you should be able to simply use the print and the export to PDF buttons available in the ribbon without any coding.

To Print: With the form currently active: Ribbon: File: Print: (I use the preview just to see how it looks then print from the print preview context ribbon choose which option works for you) or you can simply use <ctrl><p> to go straight to the printer dialog.

To go to PDF: with the form open and currently active: Ribbon: External Data: Export Group: PDF or XPS and follow the prompts.

If you really need a button for these steps we'll be happy to help you develop the code etc.
Dec 24 '12 #2
Thank you
I will do some trying.
Thank you for the suggestions.
Ted
Dec 24 '12 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Akira | last post by:
Could someone tell me how to send outlook appointment email from asp page? I would like appointment email just like one outlook can send out. I tried to look for an answer for this, but it seems...
2
by: Kent | last post by:
Hi all, I have a .aspx page that I would like to Outlook. I can do that from the browser by: File/Send/Page by Email ...but it would be better if I cold send directly to Outlook. How can I...
6
by: toufik | last post by:
Hi, I've a crystal reports Report, Is it possible to send it by email? how? Thanks
5
by: sam | last post by:
Do anyone know how to apply send datagrid via email? Any website for reference? Please advise.
0
by: Dave S | last post by:
I have a lot of forms on our web site that require the user to fill out information and submit it back to us. currently the information comes back as name value pair. The our employee's then has to...
2
by: deepaks85 | last post by:
Dear Sir, How can I attach and send files through email in PHP? I am sending normal email through php script. It's working fine for me. Now I want to send some attached files with that mail. ...
0
by: sudhansutiwari | last post by:
Hi Friends, I am trying to port an application written in VB 6.0 to VB 2005. As I am new to .NET environment any suggestion would be highly precious for me. My Current problem is : li_mode...
1
by: steinwaygirl | last post by:
Hi all, I have been searching so hard for the answer to this, hopefully some of you all can help. I have created an HTML file with various forms - also included CSS and some javascript for...
1
by: jadeverell | last post by:
Hi, I have a database that contains information of contracts / tenders and need to do the following task: * when a contract reaches its expiry date, i want to send an automated email to notify...
16
by: Ed Bitzer | last post by:
Trying to send groups of email with program using System.Net.Mail. I do not clear MailMessage but repeatedly loop changing only the Bcc entries. Works fine if all addresses are valid. As a simple...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.