Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!
Learn how Concerto can help you.
Solved
Create a button to email field contents from excel sheet.
Posted on 2012-12-25
I have a series of worksheets (one for each project I am working on) in an Excel 2010 workbook which contain project status/issues information. I would like to email the contents of a few fields to a static recipient list every Friday as an update. Could a button be programmed to copy the contents of certain fields and paste it into an Outlook email?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
11-
5
17 Comments
I'm sure there are numberous ways this can be done, here is one way:
http://msdn.microsoft.com/en-us/library/aa203718%28office.11%29.aspx
http://msdn.microsoft.com/en-us/library/aa203718%28office.11%29.aspx
can you be more specific atttaching a sample workbook and advising which fields to be exported as email and in which format so we can provid you a working solution ?
gowflow
gowflow
Here is a sample of the workbook. I would like to send the action items sheet to the emails listed on the contacts sheet.
EXAMPLE1.xlsx
EXAMPLE1.xlsx
Sorry for the delay I did not forgot your issue. I was caught with urgent stuff at the office will look at this asap
gowflow
gowflow
Hi scottlab,
Is this what you are looking for ?
Kindly download the attached file and make sure your macroes are activated and go to the sheet contact and activate the button Send Emails.
Kindly check the results and let me know your comments. Please feel free to ask for alterations
gowflow
EXAMPLE1.xlsm
Is this what you are looking for ?
Kindly download the attached file and make sure your macroes are activated and go to the sheet contact and activate the button Send Emails.
Kindly check the results and let me know your comments. Please feel free to ask for alterations
gowflow
EXAMPLE1.xlsm
I did not have it saved local the first time. Runs without error. Can the email addresses and names be pulled from the list to accomodate expanding the email list or changing recipients?
Thanks
Thanks
What do you mean be pulled from the list ???
whatever you put in the Contact sheet wether 1 email or 1000000 it will pull them and create email for each and everyone in your draft.
With this version you will need to manually chk each mail and press send on it so it sends it. If you like it we can send it directly. You can change also the email body content. Did oyu see the emails created in the draft ?
gowflow
whatever you put in the Contact sheet wether 1 email or 1000000 it will pull them and create email for each and everyone in your draft.
With this version you will need to manually chk each mail and press send on it so it sends it. If you like it we can send it directly. You can change also the email body content. Did oyu see the emails created in the draft ?
gowflow
My mistake, it is generating drafts correctly. Is it possible to add a field value from the action items sheet (A1) as a prefix to the subject line?
please state here exactly how you would like the subject line to be and I will replicate.
Anyhow I modified the file to include A1 please chk if that is what you want.
gowflow
EXAMPLE1.xlsm
Anyhow I modified the file to include A1 please chk if that is what you want.
gowflow
EXAMPLE1.xlsm
No problem and meantime have a Happy New Year 2013 and my it bring you prosperity health and happiness.
gowflow
gowflow
Featured Post
ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.
One of a set of tools we're offering as a way to say thank you for being a part of the community.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Suggested Courses
Course of the Month5 days, 17 hours left to enroll
688 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.