Over 1 million tech questions and answers.

Automatic Outlook mail based on a column value in excel file

Q: Automatic Outlook mail based on a column value in excel file

Hello Forum member,

I am working on an excel file with hundreds of records and tens of columns. There is a column"L" which gives the date when the license key given in column "B" of a particular software is going to expire. I need to check the column and send email to Person X [email protected] 3 months in advance so that he can take poper action to get the license renewed. It is too much of a manual work every week.

I am looking for a macro that can send an email to person X stating that license key value given in coumn B is due to expiration in 3 months from today(based on value given in column L)

I have seem a similar thread in the forum giveb below but i need changes to it. Unfortunately, the thread is closed and i can not contact the person who gave the solution. I am not able to modify the code shared to match my requirement.
Automatic Outlook mail due date reminder based on Excel file

http://forums.techguy.org/business-applications/1129238-automatic-outlook-mail-due-date.html
Can anyone please modify the code given in the above thread to match my requirement. Please!!Thank you!

RELEVANCY SCORE 200
Preferred Solution: Automatic Outlook mail based on a column value in excel file

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Automatic Outlook mail based on a column value in excel file

Read other 8 answers
RELEVANCY SCORE 122.4

Hi,

i have used the following to get automatic alerts setup when a due date is near:
https://forums.techguy.org/threads/...ue-date-reminder-based-on-excel-file.1129238/

but instead of this looking at the due date column, i would like it to look at a conditonal formatted column, which shows status as either "due" and "expired" depending on due date. i would like it send out to all those with "due tag and not "expired"

I have name in column A, details in column B, emails address in column C, status in column i, and reminder in column k
Somethng else i would like to do later on, if at all possible,is to get a particluar email from outlook be transfered to excel and and then emailed to specific people based on a status column. So if an email is recieved to say a project is extended or cancelled,, it contents is copied to excel and emailed back out to certain people.
Thank you for your support.
 

Read other answers
RELEVANCY SCORE 121.2

Hi Everyone!

This is my first post here. I need your help in developing a mechanism to send an automated outlook mail, when the due date of a payment is 10 days away from the current date. The script should preferably run automatically every time the PC is running. without the excel file necessarily open.

In the attached excel file, An email should go of to -email address (Col. Q), with subject "Vendor Payment (Col. C) is due on Due date(Col. M)", and body "Dear Name(Col. P), please update the payment status".

Also, the script should put a check mark on Reminder sent column (Col. Q) after the mail is sent, the script should also check if the value of the cell is blank before sending email.

I have scored the forum for similar problems, and although I found a number of threads, I am not proficient enough in VBA to modify them to my needs.

I'd really appreciate any help,
 

A:Automatic Outlook mail due date reminder based on Excel file

Read other 15 answers
RELEVANCY SCORE 121.2

Hi Everyone!

This is my first post here. I need your help in developing a mechanism to send an automated outlook mail, when the due date of a project is 7 days away from the current date. The script should preferably run automatically every time the PC is running. without the excel file necessarily open.

In the attached excel file, An email should go of to -email address (Col. D), with subject "Project (Col. B) is due on Due date(Col. C)", and body "Dear Name(Col. A), please update your project status".

Also, the script should put a check mark on Reminder sent column (Col. E) after the mail is sent, the script should also check if the value of the cell is blank before sending email.

I have scoured the forum for similar problems, and although I found a number of of threads,I am not proficient enough in VBA to modify them to my needs.

I'd really appreciate any help,

Thanks
 

A:Automatic Outlook mail due date reminder based on Excel file

Read other 8 answers
RELEVANCY SCORE 121.2

Hello all,

I'm receiving mail alert based on date only, it is not considering the month into the account.. Kindly suggest..

Attached the excel file with macro...
 

A:Automatic Outlook mail due date reminder based on Excel file

Read other 16 answers
RELEVANCY SCORE 107.6

HI, Its my first post here. I need to send reminder mails from outlook based on excel reminder dates.
For this i should not open excel neither i know VBA scritping for this.
Please provide help on this.
As i attached my file i need list of assets need to be calibrated ahead of 45 days of calibration due date.
 

Read other answers
RELEVANCY SCORE 90.8

I need some help. I am trying to come up with a formula that counts the times that a "string" occurs based on a value in another column.....
Example:
Everytime column a = "Jones", check if column e = "tom".....if so count it.
 

A:Counting strings in one column based on Condition in another column in Excel

The EASY way to do this is to concatenate columns A and E using (for instance) this formula:

=A1&E1

or

=A1&" "&E1 (puts a space between two words)

Then count the individual field. Make sense? Will it work for you?

------------------
~dreamboat~
Brainbench MVP for Microsoft Word
Brainbench
 

Read other 3 answers
RELEVANCY SCORE 88.4

Hi, I am really new to excel so I am hoping to get some help here. I have searched through the forum and tried several codes, but I was not able to run it successfully.

Basically in my excel file, i have a long list of documents with their respective expiry dates. I want excel to send me an email when it is 6 months before the expiry date.

I have uploaded a sample file on what my worksheet will look like.
I am using Microsoft Excel 2010.

Thanks!
 

Read other answers
RELEVANCY SCORE 88

I have a very large spreadsheet with thousands of rows and about 20 columns
Col A has either of 4 values North, South, East, West
The other Cols have numbers
I want to get a total for North, South, East, West for Col B, C etc
Is there a formula I can use something like (if Col A = North , total ColB is )
Don't want to keep resorting by Cola and putting in Subtotals
Hope I have explained it well enough

Thanks

Brian
Dublin, Ireland
 

A:Excel Total in a column based upon value in another Column

yes you can use
SUMIF()

SUMIF(A:A, "north", B:B)

OR if you put the values North, South etc into a new column - Say Z2,Z3,Z4,Z5

SUMIF(A:A, Z2, B:B)
and copy down

if not - please upload a sample
Please upload a small clean sample of your data / workbook (not a picture) to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
We would like to see an example of your data and also a manual mock up of the expected results you want to achieve.
 

Read other 3 answers
RELEVANCY SCORE 82.8

Dear All,

I am creating a tracker file for Purchase Orders in which end date in column 'J' is very important.
Column 'J' has following conditional formatting
1. If cell date is in between todays date + 14 days --- YELLOW
2. cell date <= today's date ------------------------- RED
3. cell valus > today + 14 days ---------------------- GREEN

So now when the cell turn Yellow I want the excel should send the mail to the concerned person whose mail id will be mentioned in same row of column 'G'

One more requirement there should be two mails. Reminder 1 & Reminder 2.

I use officer 2010 & mail is outlook 2010 & OS is windows 7.
This file will be on share point. This file may not be opened everyday.

Please reply with the procedure as I am not a programming/ IT person... I may not understand all terms.. please try to simplify the response.
Thanks in advance for all the help.
 

A:Auto mail from Excel to Outlook based on date in cell

Hi there, welcome to the board!

You'd want a location to mark when an email was sent. I'm assuming you want a worksheet change event for this, which will basically always run when a cell on this specific worksheet is changed. There are other events you could use to fire it off, like the calculate event. You could, if you wanted to, assign this functionality to a button, but then it wouldn't be automatic.

The below code does what you ask. It goes in the worksheet module of the worksheet your data is on. To get to it, right click the sheet tab name and select 'View Code', then paste this there.

EDIT: The locations to mark when an email was sent (btw) were columns K and L, as you'll see them set as constants at the top of the code. You can change those letters to any column you want to house it in. It just puts the current system date in those cells, and that will be checked when the values in column J are checked. If nothing is there it assumes an email hasn't been generated yet and will do so. But if it has a value - any value, it will ignore that row.

Also, I assumed a 'yellow' highlighted value was your first reminder, and a 'red' highlighted value was your second reminder. It uses this as text in the subject and body of the email.
Code:
Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)

Const ReminderOne As String = "K" 'column letter
Const ReminderTwo As S... Read more

Read other 1 answers
RELEVANCY SCORE 80.4

Hi,
If I have a column A with dollars in it, and column B with dates,
how could I write a formula to give me the total of column A
only when the date in B falls between 8/1/02 and 8/15/02?

I can get it to work if I say "<8/16/02" or ">7/31/02", but I can't get the range syntax....

Thank you!
kimmer
 

Read other answers
RELEVANCY SCORE 79.6

I have attached two images of an Excel worksheet. I have gone to the trouble of taking multiple sets of three columns of associated data, that is data of x, y, z where y and z are associated with x. In building a new table with six sets of data, I put x1, x2, ..., x6 in a single column, and then spaced out y1/z1, y2/z2, ..., y6/z6 in separate columns before a sort. I then sorted on values x (all x1 to x6 in a single column).

The result is shown in the first image "pre-combine-rows"

You can see that in column "all x," many rows have identical values: for example there are five rows with value x = 218.9, and six rows with value x = 224.9. I want to combine all those rows, which combines also the values in the columns y1/z1 through y6/z6.

The result should look like the second image: "post-combine-rows"

20 rows has been combined into 5 rows.

This is a walk in the park for Excel, right? Does not even need a macro, right?

Is this one of these Database/Criteria setups?

A:Excel: Combining Rows Based on An Equal Value in One Column

Hi mavigozler,

You wouldn't require a macro to complete this feat. You can achieve the wanted result with formulas. If you still need help with this issue, I'll be glad to elaborate a formula for you.

Regards,
Peatawn

Edit: You can also have a look at the Excel matrix feature...

Read other 4 answers
RELEVANCY SCORE 79.2

Hi All.

Hi i have a excel file which has Serial No , Task and date of completion as 3 ccolumns.
I keep on missing the tasks. I heared from somwwhere that we can create automatic reminder in outlook based date picked from excel. I want the same. Example on 1, april, 2010 - if i have to go to my lawer, the in outlook on 1st-Apr-2010 a reminder comes , visit to lawer Mr. XXXXXX.

If any one can help that would be of great help.

Regards,
sam
 

Read other answers
RELEVANCY SCORE 76.8

While using XP, I used Pegasus mail as my e-mail client. Pegasus's mail filtering options included the ability to set a duration on a mail folder such that any message in that folder, older than the specified duration, was automatically moved to the deleted mail folder.

Is there any way to achieve the same thing using Windows Mail under Vista?

Thanks

Tony

Read other answers
RELEVANCY SCORE 76

I am trying to hide rows of my worksheet that show a date in the completed column.
The orders that are complete have a date in column F up to this point I highlight them green so I know they are completed but it would be nice if they highlighted green and were hidden when a date was entered into the completed column.
Can someone assist me with creating a macro that will do this?
I am very new to macros so please forgive my lack of knowledge.

I have attached a sample of what I am doing however inf has been changed.

I am using Excel 2007

Thank you,
 

A:Solved: Macro for excel 2007 to hide rows based on any data entered in a column

Hi, welcome to the forum,

I put some simple code in the Sheet's vba

Make sure you allow macro's to be run

Just enter a date in the last row of column F for testing.

For the other green rows, just click in column F and update the date by retyping it
 

Read other 3 answers
RELEVANCY SCORE 75.2

Hi. I'm having big problems with something that might be very easy to do, although I tried (and searched how to do it) without success:

I've got a sheet, with 'Date/Time' as first column.
I can select that column, along with any other to insert a graphic chart into the worksheet and it works fine.
My question is.... how can I make Excel generate automatically ONE CHART for each column, with 'Date/Time' as X axis? I tried some dynamic table/charts but it looks incredibly messy (it's faster for me to create the charts one by one, manually!).
Thanks for your help.
 

Read other answers
RELEVANCY SCORE 72.8

Hi All,

My name is Diego.

Can anyone send me code to automatically send me an email when the date listed in "column J" is the same date as today. Also, it needs to email only once and even if I am not running excel or at my computer. I want to use Microsoft Outlook and use the ClickYes program as well if this helps that was talked about by Zack Barresse in

http://forums.techguy.org/business-a...s-using-2.html
Essentially I have to be reminded of a reapplication for specific state licensures on healthcare courses I provide. I don't want to forget which courses I have to reapply for so I need to have a program that will look at a date which I have in column J and then email me to remind me of this.

BTW - I am using Outlook 2007 and Excel 2007 on Vista.

Thanks. I appreciate your help! Also, extra points and praise for the person who solves this problem!
 

A:Automatic Email from Excel based on Date in Cell

Read other 16 answers
RELEVANCY SCORE 72.8

I have a personnel tracker that tracks required documents that need to be renewed every year. There are 4 of these and each has a seperate column for each date. They are J,L,T and U.

I would like excel to scan each of these columns every time the document is opened for any of those dates that are 60-65 days from expiring, I use Now()-300 to check this.

But if the cell is blank I want it ignored, which right now it does not. If it finds 1 or even 80 that are in that range I want 1 email generated to a list of management personnel.

Currently it generates how ever many are blank or expiring. I use outlook.

My data starts on row 3 and goes down to 331, the required and maximum number of people allowed on the contract.

If I can get just one email with a generic message I would be happy. But if I could I would like the info that is actually doing the triggering to be copied and pasted in the email to include the info in A, C and D.

Here is my current code, I would change .display to .send once I have it working. please help.

Private Sub Workbook_Open()
Dim Cell As Range
Dim DateRng As Range
Dim Msg As String
Dim olApp As Object
Dim olEmail As Object
Dim RngEnd As Range
Dim Wks As Worksheet

Set Wks = Worksheets("Work Site Info")

Set DateRng = Wks.Range("J3")
Set RngEnd = Wks.Range("J331")
Set DateRng = IIf(RngEnd.Row < DateRng.Row, DateRng, Wks.Range(DateRng, RngEnd))

'Change this to what you want.
Msg = "This is message is the bo... Read more

A:Solved: Automatic email from excel based on date

Read other 16 answers
RELEVANCY SCORE 72.8

Hi Everyone!! This is my first post here. I need your help in developing a method of sending automated emails on Gmail when the due date of Insurance payment is 7 days before the current date and an email when the due date has expired.

So as per the attached excel file an email should go to (Col H) when due date (Col F) is 7 days before current date, with the message "Payment of Rs. (Col E) is due for Policy Number (Col D), (Policy name (Col C)) for (Owner name (Col B))"

I have searched through various forums for similar problems but could not really find a solution, as I am not proficient with VBA to tweak the code as per my needs.

Any help would be really appreciated!

Thanks
 

Read other answers
RELEVANCY SCORE 72

Hi All,

My name is Diego.

Can anyone send me code to automatically send me an email when the date listed in "column J" is the same date as today. Also, it needs to email only once and even if I am not running excel or at my computer. I want to use Microsoft Outlook and use the ClickYes program as well if this helps that was talked about by Zack Barresse in

http://forums.techguy.org/business-applications/710581-solved-automatic-email-alerts-using-2.html
Essentially I have to be reminded of a reapplication for specific state licensures on healthcare courses I provide. I don't want to forget which courses I have to reapply for so I need to have a program that will look at a date which I have in column J and then email me to remind me of this.

BTW - I am using Outlook 2007 and Excel 2007 on Vista.

Thanks. I appreciate your help! Also, extra points and praise for the person who solves this problem!
 

A:Automatic Email Reminder from Excel based on Date in Cell

Please do not post duplicate threads.
One thread per issue.
Continue replies for this issue in this thread: http://forums.techguy.org/business-applications/856705-automatic-email-excel-based-date.html
Thank you.

Closing thread.
 

Read other 1 answers
RELEVANCY SCORE 71.6

Hi,

I am in dire need of a solution wherein I want outlook to shoot an automatic email based on date from calendar or excel. Basically I have some users assigned some privileges which are assigned for a specific period. I need the mail to go out to them may be a day or two prior to the target date.

I came across this thread:
http://forums.techguy.org/business-applications/1129238-automatic-outlook-mail-due-date.html

I copied the code the in outlook VBA editor (i already have one script there and since being new to this i do not know if two scripts would be ok to have in there.... ...ScreenShot attached). However just to try when i ran the rule it gave me an error (screenshot attached).

I can't reply to the same thread since that is closed.

can you please help in this regards...

-regards,
gsg
 

A:Solved: automatic mail delivery based on date/time

Read other 9 answers
RELEVANCY SCORE 70.4

Hiyo.
To begin with, I just want to check if this is viable, and if so, which solution is best/easiest...

Office 2010.

Current situation:
An Outlook rule moves certain messages to an Outlook folder.
A macro button is used to run code that prints the attachments of all messages in that folder.
Think it then deletes the messages.

Required situation:
Instead of printing all attatchments, the macro needs to look at a specific column of data in an Excel file.
If a value in the Excel column matches (or part matches) the filename of the attachment, the attachment is printed.
All attachments with filenames that do not match the Excel list are left alone.

Alternatively, switch it round, so the macro is in the Excel file, and it checks the values in the column against the attachment filenames of messages in that Outlook directory, and prints those that match.

Alternatively, write something in Outlook code, perhaps using a form control, whereby the user can enter (paste in) the batch of values, and it then prints attachments accordingly, rather than trying to forge a link between Excel and Outlook.

Alternatively... use some 3rd party tool that accepts the batch of values and interacts with Outlook to print the attachments, bypassing the need to write and manage code.

Or something else?

Cheers.
 

A:Outlook/Excel - Print selected attachments based on Excel list

Alternatively... modify the existing Outlook macro to save all attachments to a dir on the PC instead of print, and then write an Excel macro to check the files in the dir instead of the Outlook folder.
 

Read other 1 answers
RELEVANCY SCORE 70.4

Hi,

I am trying to send some reports to a set of IDs. Referring to the enclosed excel will help understand the issue.

Column A has the set of IDs to whom mails have to be sent.
I need to filter out the data pertaining to the IDs and send only relevant data to respective people.

For eg: Lets take the vakue 1 in column A. I want excel to filter out 1 in column A and send the details from B1 to I5 to the ID 1. Similarly for ID2 and so on. I use microsoft outlook to send emails. Outlook recognizes these IDs, so the email addresses are not required to send the mail. Just ID would do.

Can some content also be added, apart from just providing the data.

Is this possible and if so can someone please share the code for the same. Im just a beginner. Looking forward to some assistance.

Thank you.
 

A:Send mail from excel to unique values in a particular column

Welcome to the board.

1. I checked Ron de Bruin's site, his Mail Range or Selection code looks like it'll do the job with a little tweaking for your requirements.

2. For the tweaking to work, the data must be pre-sorted by column A.

3. To run the code, you must select a data cell (i.e. any cell in A2:I10) & then click the "Mail Range" button.

4. The tweaking is: (i) a few lines between "added code" & "end added code" (ii) the Set Source = Range line (iii) the .To = Addressee line.

5. There's also a line .Display ; needs to be changed to .Send if automatic sending is required. Near that line are others such as Subject = "This is the Subject line" and Body = "Hi there", adjusting those would cover "Can some content also be added?".

6. To view the code, press ALT+F8, highlight Mail_Range, click on "Edit".

HTH
 

Read other 2 answers
RELEVANCY SCORE 67.2

Dear Friends,

I'm in a serious need of updating the respective teams with reminders on due dates of statutory compliance requirements. I've developed an excel workbook having three sheets namely Permissions, Returns and Records. All the three sheets are having due dates. (Workbook is attached for your solution please)

I need your expert solution in sending an e- mail message as a reminder to the person concerned before 15 days of due date with an optional text of my choice.

Its not possible for me to open neither the excel sheet nor the ms outlook application on a time basis coz my profile mostly deals with Industrial Relations aspects. Hence I've to be in the field 12/7 during the shift period and on call 24/7.

Awaiting early reverts.

Regards,

SNU.
 

Read other answers
RELEVANCY SCORE 66.4

I'm trying to open in Excel 2010 a file with .exf extension that is always a pipe delimited text file. I have set, using Windows file associations, to open this type of file with Excel. But, I would like for it to recognize that it is pipe delimited, so that I don't have to click on Delimited, Other, "|" to import the file. Any ideas? I also thought about using a macro to save some steps as well. Thanks for your help!
 

A:Excel import pipe delimited file based on file extension

Hi, welcome tothe forum
Macro is the solution, just start the macro recorder, give it a name and do what you do, stop the recorder and you have the macro.
Simple as pie
 

Read other 3 answers
RELEVANCY SCORE 66.4

Excel 2007 for PC

Rookie Excel user requesting help writing a macro that will overwrite information in one column, based on information in a second column. See attached file.
 

A:Solved: Macro that overwrites info in 1st column based on info in a 2nd column

Read other 7 answers
RELEVANCY SCORE 65.6

Hi,

Iam new user to this site and also New user to Excel application.I want your guidance in the below -

I want to know how to send automatic mails from excel(a range of cells to be copied and must be pasted in body of the mail and send mails to defined mail ids).
Is that possible?
Need - Every month i want to share some reports/values with some group of ids.So what iam doing is collecting the data from different sources and merging in one single excel.Upto here is ok with me..coz its diffiult to automatize collecting information from different sheets.
Then i will copy some range of values and sends to paste it in body of outlook mail and sends to the group of ids.For this i want solution.Is there any option in excel that i can click or run.so that it automatically sends that range of values to defined mail ids in body of mail.
It will be greatly helpful if i got solution to this question.
Iam using windows7 licensed version.MS Office 2013.I cant load any third party/non licensed version softwares in my laptop.

 

Read other answers
RELEVANCY SCORE 65.6

Hello Techguy!

I noticed a thread from earlier on, although I am still a little in the dark

I am making an interactive checklist with a deadline timer, and when this timer goes too low, I'd like excel to send an e-mail to me. Much like the thread in http://forums.techguy.org/business-applications/710581-automatic-email-alerts-using-excel.html.

I know it's in Danish, but this is my workbook.

Now the words don't really matter The text I would like to get e-mailed is the "I" culoumn.
Also please do not change the 2nd sheet (Ark2).

OS is XP, Excel is 2010 and I have Outlook 2010 as well.

Your help would be much appreciated!
 

A:Automatic e-mail from excel

Read other 16 answers
RELEVANCY SCORE 65.6

hi everyone, this is my first post on techguy. I really need help with a Microsoft Excel spreadsheet. The workbook consists of gauge numbers and their calibration due dates.

Can someone please help me so that Microsoft Excel automatically sends a mail to a particular email address when the due dates are about to pass in a day/have already been passed?

The mail should state that the following gauges are due for calibration.
Any help will be appreciated. thanks
 

A:Excel automatic mail.

Read other 16 answers
RELEVANCY SCORE 65.6

I have a list of 39525 emails in column A and a list of 19909 emails in column B. If an email exists in column B that also is in column A I want it removed from column B. PLEASE HELP! THANK YOU!!!!!!
 

A:Solved: Excel 2010 - Remove duplicates from column B that exist in column A

Read other 9 answers
RELEVANCY SCORE 65.6

Hello everyone.

I am trying to tweak a macro that was posted on this forum some time back, but I'm a bit of a N00B. The macro is from this thread that is now locked: https://forums.techguy.org/threads/...ue-date-reminder-based-on-excel-file.1129238/. What I am looking to do is generate two different emails whenever the value of a cell changes. All the data that needs to be part of the email is included in various cells. I've included sample data. If possible, could you provide code for generating the email and another for sending the email without opening Outlook (i.e., as soon as the value changes)? I've included sample data for your consideration. Thanks in advance for any help you can provide.

When Cell Value = In Progress
The email I'm hoping to generate (I've mapped it with the cell contents I'm hoping to pull) will be as follows when Column F changes to In Progress. The email addresses are in Column G.

Subject Line: "Web Request(s) Now In Progress"

Dear D2,

Your C2 B2 request has been received and is now in progress. Thank you!

My Signature

When Cell Value = Completed
The email I'm hoping to generate (I've mapped it with the cell contents I'm hoping to pull) will be as follows when Column F changes to Completed. The email addresses are in Column G.

Subject Line: "Web Request(s) Completed"

Dear D2,

Your C2 B2 request is complete and the changes are now live. Thank you!

My Signature
 

Read other answers
RELEVANCY SCORE 65.6

I have to many separate mail accounts used for my business. I forget to check them all. Can I convert my web based accounts, over to my outlook, but have mail sent from my different business accounts. Let me know if this is not clear what I'm trying to do. I need to keep my existing addresses. There printed on all my business cards.
Win98se, outlook200
 

A:Can I convert web based e-mail to outlook

Read other 6 answers
RELEVANCY SCORE 65.2

Hi Everyone,

Seriously need your help ><"
I am using MS Office 2010 and Windows 7

I have a data like this (The number of Products and Shops are much more)

I want the result to be like this

This is the attached file for you to download the data or you can simply download from the attachment in this post
http://www.sendspace.com/file/iqvlce

I would really appreciate the help of the community
Kudos to everyone!!!!
 

A:Excel Macro - Merging multiple column into single column

in a new cell, create the following formula.
=A1&" "&B1&" "&C1

Or isn't this what you want?
(the cell-numbers are those which you want to combine).
You can copy the formula for all cells (haven't seen your file, find the link a bit tricky, maybe attach the file in a post here)
 

Read other 3 answers
RELEVANCY SCORE 65.2

Hi Rollin_Again and everyone in this forum,

Hoping someone could help me in my problem.
I have a workbook in Microsoft Excel 2010 (Windows) of about 60.000 rows of words in different languages.

Some words have 5 different languages and some are only 4 or 3, all are written in Column A of the workbook.

Column A
English -------(in color Orange)
Spanish -------(in color Red)
Italian ------- (in color Blue)
German ------ (in color Black)
Papiamento ---(in color Green)
etc.

What I want is a Macros Program that can put all Spanish words (red color) in Column B, all Italian words (blue color) in Column C, all German words (black color) in Column D, and all Papiamento words (green color) in Column E.

Like for example:

Column A --- Column B ---Column C --- Column D ---Column E
English -----Spanish ----Italian ----- German --- Papiamento
etc.

Thank you very much in advance and I'll appreciate all the helps you could give me.
sukisuki
 

A:Transfer texts from Column A to Another Column, Excel 2010 (Windows)

Read other 9 answers
RELEVANCY SCORE 65.2

Hi ! This refers to the subject of "Automatic email from excel based on date", and relevant thread http://forums.techguy.org/business-applications/927675-solved-automatic-email-excel-based.html

This was fantastic. Only one issue remaining.
This is generating multiple emails and even the items not due are generating blank mails.
I would like to generate only one mail with different items different expiration dates.
After that group the identical addressees and compose one message with all the relevant data.
Awaiting kind help.
 

A:Need Help reg "Automatic email from excel based on date "

Read other 7 answers
RELEVANCY SCORE 65.2

Good day,

I was looking for someone to help me in this:

Please see the attached excel file, which automates Groupwise mails for due date reminder. However, it generates individual mails for each due items, whereas, I want one single mail with all due dates. How do I achieve it?
 

Read other answers
RELEVANCY SCORE 65.2

Hello all,
I am new to Tech Support Guy and to macros/VB code. I hope my question make sense! I have looked at other threads
but I don't even have the understanding of which bits of code are adaptable to my needs.
My colleagues and I run Office 2003 (with Excel and Outlook) and share a spreadsheet of client data to allow us
to co-ordinate our business with them.
At present our work is overly dependant on individuals remembering to action a task, and on paper lists in
different places. I want to try to bring us up to at least the 20th Century!
Our principal concern is when paperwork is due to expire and needs sending off by post to another team
to re-validate the paperwork (column M). I would like the spreadsheet to keep track of when paperwork is expired and to send
an e-mail alert to myself and my colleagues to make sure that we can get it sorted.
The e-mail would say something like:
subject: 'Charts for signing'
Main text: The charts that require new signitures are:
...and then a the rows of the spreadsheet listing the clients that have expired paperwork.
I enclose the spreadsheet with a couple of fake examples to try to explain what I mean. In this example I would want the
information in the bottom row (or at least the first three columns from this row) to be detailed in the email. I would not
have the ability to install software that could help with the process.
Each time we had re-validated paperwork sent back to us the spreadsheet could be updated... Read more

A:Automatic e-mail sending from Excel

Hi, welcome to the forum.

I'll have to think it over but meanwhile I've downloaded the file and will see if I can offer any ideas. Don't hold your breath
 

Read other 3 answers
RELEVANCY SCORE 64.8

I have a spreadsheet that I would like to give to both English and Spanish speaking workers. Is there a way to convert the English text in column A to Spanish in column B? I will be changing the text in column A on a weekly basis and will need to translate then distribute to all workers.

Thanks in advance.
 

A:Excel - Translate English in Column A to Spanish in Column B

Read other 8 answers
RELEVANCY SCORE 64.8

COLUMN A
5
5
6
9
COLUMN B
A
A
B
B

A=10
B=15
Hi there, I need help creating a formula that adds Column A, only if Column B = 'A'.
I then need to multiply that counted value by another cell.

Can someone please help me? I think I'm over-thinking this.
 

A:Excel: Count Values In One Column On Basis Of Other Column Value

=SUMIF(B1:B4,"A",A1:A4)

Where B1:B4 is where your A and B values are, and A1:A4 is where your numbers to sum are located.

HTH
 

Read other 1 answers
RELEVANCY SCORE 64.4

I have a database that i'm creating that has 3 different tables. Its for safety violations at work. One table is the innitial one that has all the pasic information on it. I set it up so that it automatically assigns a number to each complaint filed. The other two are for follow up. One is for how the problem is going to be fixed and who is supposed to do it, And the other one is for verification to make sure that the problem has been fixed. My problem is that i want the two follow up tables to automatically import the complaint number when a new complaint is filed. I tried to set everything up myself, but had no luck. Can someone please help? Thanks.
 

A:Solved: update the column in one table based on the column of another table

Read other 16 answers
RELEVANCY SCORE 64.4

Hello helpful people,

I'm trying to migrate my Outlook Express email messages from my old XP laptop which suffered a motherboard death last week. I've got the hard drive connected via external enclosure to my Vista Ultimate 64-bit desktop. I didn't have any trouble getting Windows Mail to locate the .dbx files and import the appropriate folders, but when I add the "Account" column to the message view, there is no data in there. I've got 8 accounts funneling email into this program, so it's rather critical that I have the information readily available in the window.

I read somewhere that anti-virus software might be removing the data, so I tried the import with my anti-virus and Windows Defender both disabled and still no luck. Thinking it made a difference once before when upgrading my hard drive, I tried doing the import with all the account information set up under "Tools" --> "Accounts..." and then again without any set up at all. Same result both ways.

Anyone have any ideas how to get the import to include the Account column information? Much appreciated. Thank you!

A:Missing Account column info when importing messages from Outlook Express into Windows Mail

Well, looks like no one has a solution for me. Does anyone else have this problem? Am I all alone here? :o)

Read other 3 answers
RELEVANCY SCORE 64.4

Is there a way to have Excel 2007 to automatically send a document by e-mail (not an XLS file)?
 

A:Solved: Excel 2007 Automatic E-mail

The below is a cut-down of this code.

Note that (i) client is Outlook (ii) early binding requires setting a reference to Outlook in Excel's VBE before use.

HTH

Sub SendWithAtt()

Dim olApp As Outlook.Application
Dim olMail As MailItem
Dim CurrFile As String

Set olApp = New Outlook.Application
Set olMail = olApp.CreateItem(olMailItem)

With olMail
.To = "[email protected]"
.Subject = "This is the subject"
.Attachments.Add "C:\Documents and Settings\Andy\My Documents\test.doc"
.Display
.Send
End With

Set olMail = Nothing
Set olApp = Nothing

End Sub
 

Read other 3 answers
RELEVANCY SCORE 63.6

Hi,

I have a query but I'm not sure if it's even possible to do.

If I enter a name into cell J1 I want to check for this name in column H then for each row that is found on I would like to sum column B and output the result to cell J2. E.g. If I enter Paul into J1 I would like to search for this name in column H. For every row this is found on I would like the B cell for that row to be included in a sum of which the result is output to cell J2.

Is this possible and if so does anybody know how?

Cheers
Paul
 

A:Solved: Excel - Search for value in one column, sum a different column

yes, SUMIF() should do that

i'll edit - and add an example

enter into J2

=SUMIF(H2:H9,J2,B2:B9)

see attached example file
 

Read other 1 answers
RELEVANCY SCORE 63.6

I hid all but three columns and if I right-click on column A to insert a column, it becomes column B and no column is to the left.

A:In Excel 2007, how do I add a column to the left of a column when there is only 3?

I have Excel 2007
I put the cursor in column A, right click, and then insert.
Insert entire column. It appears to the left. Is this what you are doing

Read other 4 answers
RELEVANCY SCORE 62.8

Hello, I have been having trouble parsing out the code for an automatic notification system that will send out an email when a certification is about to expire. I keep getting error messages on one or two lines of code. I have attached the code that I have so far and a dummy spreadsheet of what I am trying to accomplish. The goal is to explore the automatic email notification option for the LEOSA Expiration date (column D), the Concealed Carry Permit Expiration (column G). For column ?D? and ?G ?, when an expiration is within 90 days the box turns yellow and sends a notification email. When the expiration is within 30 days it turns RED and an email notification is distributed. At each of these milestones (90 and 30 Day) the request is to determine if an ?auto send? type process can be utilized.

Tech Support Guy System Info Utility version 1.0.0.4
OS Version: Microsoft Windows 7 Enterprise, Service Pack 1, 64 bit
Processor: Intel(R) Core(TM) i5-2500 CPU @ 3.30GHz, Intel64 Family 6 Model 42 Stepping 7
Processor Count: 4
RAM: 3984 Mb
Graphics Card: Intel(R) HD Graphics, 1800 Mb
Hard Drives: C: 465 GB (400 GB Free);
Motherboard: Hewlett-Packard, 1495
Antivirus: Symantec Endpoint Protection, Enabled and Updated
 

Read other answers
RELEVANCY SCORE 62.4

Hello there,

I am pretty new to excel overall and facing a problem currently by setting up an automated process sending emails via Excel to Outlook.

*What*: I need to send out multiple cell values (which are calculated by formulas) on a weekly basis to 25 people.

Is there any (easy) automated process I could use? I've read online about using macros, but I am quite unfamiliar with that process.

I appreciate your help with this!

Thank you and best,

Regina
 

Read other answers