Avatar of scottlab
scottlab
 asked on

Create a button to email field contents from excel sheet.

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?
Microsoft ApplicationsMicrosoft Excel

Avatar of undefined
Last Comment
gowflow

8/22/2022 - Mon
Darren S

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
gowflow

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
scottlab

ASKER
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
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
gowflow

ok no sweat will revert shortly with solution
gowflow
gowflow

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
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
scottlab

ASKER
errors out on line:

NewWb.SaveAs Filename:=NewWBName, FileFormat:=xlExcel8


Thanks
scottlab

ASKER
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
gowflow

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
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
scottlab

ASKER
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?
ASKER CERTIFIED SOLUTION
gowflow

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
gowflow

Any news ? hv you had a chance to try the proposed solution ?
gowflow
scottlab

ASKER
gowflo,

  I am traveling for a few days.  I will test it thoroughly after the 1st.

Thanks
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
gowflow

No problem and meantime have a Happy New Year 2013 and my it bring you prosperity health and happiness.
gowflow
gowflow

Any chance to hv test it ?
gowflow
gowflow

Any news ?
gowflow
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
gowflow

Tks for the points but would like to hear your final comment is it exactly like oyu want ? if not pls let me know.
gowflow