?
Solved

Send email from Microsoft Excel worksheet

Posted on 2014-03-08
3
Medium Priority
?
530 Views
Last Modified: 2014-03-10
Dear Experts,

We have an excel file with staff salary pay slips. Could you please suggest the easiest way to email all the pay slips to the concerned staff at once?

We use google apps for email.
If required, we can setup outlook as well.

We are using Office 2003 but can change to 2007 if that helps.

Thanks in advance

JCT
0
Comment
Question by:jct_777
[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
3 Comments
 

Expert Comment

by:fhandley
ID: 39915537
Is this what you're looking for? (mail merge with attachments)

http://www.msoutlook.info/question/65
0
 
LVL 27

Accepted Solution

by:
MacroShadow earned 1500 total points
ID: 39915560
The easiest way is using CDO.

http://www.cpearson.com/excel/Email.aspx
http://www.rondebruin.nl/win/s1/cdo.htm

If you want step by step guidance please upload a sample of your workbook (using fictitious data of course) .
0
 
LVL 1

Author Closing Comment

by:jct_777
ID: 39919573
Thanks MacroShadow. Your links helped!

JCT
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Changing a few Outlook Options can help keep you organized!
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
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

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question