473,225 Members | 1,274 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,225 software developers and data experts.

Create a clickable button in Excel that opens a blank email in outlook but attaches t

I have created a button on Excel which I would like, when clicked, to attach the completed workbook to an email and be sent directly to a mail recipient.

How do I do this? The button has been created and is clickable I just need the process of embedding the/a code to it and what that code is!

Many thanks
Oct 10 '18 #1
2 4236
3,653 Expert Mod 2GB
With MS Excel, that is a bit more involved than a simple point and click. This involves Office Automation and declaring an Outlook Object. The "answer" to this is an involved application.

I would recommend you search for VBA Office Automation Outlook, and this will give you some tools (often in the form of tutorials) that can walk you through the steps. Typically we will not do that for you on this forum.

Hope this hepps!
May 13 '19 #2
5,501 Expert Mod 4TB
Read through the following Access Insights articles.
While they relate to Access, the concept will be the same for VBA in Excel.

home > topics > microsoft access / vba > insights > application automation

I and TwinnyFo has an article here too...
home > topics > microsoft access / vba > insights > sending e-mails via outlook - one developer's approach

So, once you have a general understanding of application automation from these two articles we can build on that information/understanding.

Try writing the VBA for the command button and see if you can get the code to compile and run successfully on your PC. There will be some slight changes in the vba code from what is in the articles, but not much, simple stuff like we'd remove some of the database specific code and insert the Excel references - really very minor.

If you cannot get your code to work, then please post back your code to this thread, Insert as text in-line format with the [CODE/] tool, and we can help you tweak the code to get it to run.
May 17 '19 #3

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

Similar topics

by: Roedy Green | last post by:
..button /* clickable button */ { background-color : #f1f391; color : #7b3e00; border : 3px outset #d2d2d2; margin : 0px 2px 0px 2px; font-family :Arial,Helvetica,sans-serif; font-size : 120%;...
by: Sharon | last post by:
I'm using the PropertyGrid control, and I want it to show a button. But I set the PropertyGrid.SelectedObject with a object that as a Button property, the PropertyGrid shows the buttons properties,...
by: maldita | last post by:
Hello, I want to create a button that when clicked, the webpage will then be in the body of Microsoft outlook ready to be emailed. It is for our office maps. People here have difficulty using the...
by: crazychrisy54 | last post by:
Hi there I just wondered if there is any way using GD to insert a clickable button or some clickable text into a image? It is possible to create images for buttons but what if you want a...
by: simontindall | last post by:
Hi, I'm working on a database that contains personal details. What I'd like to have is a button next to the records email address that when clicked passes the records email address into the...
by: nicolenwn | last post by:
Hello all, Many thanks in advance again for your expertise. I need help in Microsoft Access VBA once again ): I'd like to inquire if it is indeed possible to create a button that when it is...
by: Smore | last post by:
Would like to create a button on a form to find an excel worksheet that has a matching product code and production date. The excel sheet may be in one of several workbooks in folders divided by...
by: kelhisu77 | last post by:
In ACCESS 2007 I have 2 tables that are in a 1-to-many relationship, and the Primary Key for Table A is in both Tables. I have a form with data from Table A and a command button that opens up...
by: ejlegarda | last post by:
We have a switchboard form that displays buttons based on a Switchboard table. The button opens forms based on data from Switchboard table, but opens the form with Data Mode=Add. When users click on...
by: djgeverson | last post by:
Hi there, I want to have a button on an 'admin' form whereby the user of the database would click the button and a blank email would open in Outlook for the user to enter his/her problem into. But...
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
by: veera ravala | last post by:
ServiceNow is a powerful cloud-based platform that offers a wide range of services to help organizations manage their workflows, operations, and IT services more efficiently. At its core, ServiceNow...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
by: jimatqsi | last post by:
The boss wants the word "CONFIDENTIAL" overlaying certain reports. He wants it large, slanted across the page, on every page, very light gray, outlined letters, not block letters. I thought Word Art...
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....

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.