VBA To Copy, Highlight Cells Then E-mail.
Feb 24, 2010
I have got the following code that automatically copies a range of cells within the sheet i am on and then creates a new excel workbook then sends it to an e-mail address specified.
Is there anyway i can change it so that it copies the specified range (A1:K50) but then when it pastes that range into another sheet i would like it to highlight some of the cells yellow based on what i had higlighted on the sheet when i run the vba. i hightlight B6:E10 then run the VBA, i want it to copy A1:K50 into another sheet (as below) but then on the new sheet highlight cells B6:E10.
View 2 Replies
ADVERTISEMENT
Sep 14, 2012
We need to send multiple mail with attachment with outlook 2007 with option "Resend this message", now we want to use excel for sending the mail.
procedure.----------------------------------------------------------------------------------------------------
S.No. To cc----------------------------------------------------------------------------------------------------
1. xyz@ymail.com----------------------------------------------------------------------------------------------------
2. abc@gmail.com hursh@rediffmail.com, hursh@rediffmail.com, hursh@rediffmail.com, raj@hotmail.com----------------------------------------------------------------------------------------------------
3. ram@ymail.com ramesh@gmail.com---------------------------------------------------------------------------------------------------- 4. rajesh@ymail.com----------------------------------------------------------------------------------------------------
5. raghu@ymail.com raju@hotmail.com ---------------------------------------------------------------------------------------------------- 6. info@ymail.com----------------------------------------------------------------------------------------------------
7. ranjit@excel.com xyx@gmail.com----------------------------------------------------------------------------------------------------and
we have two files for attaching on desktop, one is a excel file and second is a zip file. we want to send the mail with excel mail merge.
View 1 Replies
View Related
Apr 23, 2013
I have put the following bit of code together, it selects a sheet and creates a copy , then sends a mail attaching the copy then deletes the copy.My issue is when it picks up the vaRecipient I would like the code to activate the sheet so I may see what it says in the column N - the Default is working - but I would still like to select the sheet.
Code:
Sub SendWithLotusADF()
Dim noSession As Object, noDatabase As Object, noDocument As Object
Dim obAttachment As Object, EmbedObject As Object
Dim stSubject As Variant, stAttachment As String
[Code] ..........
View 9 Replies
View Related
Aug 28, 2012
I need a macro which will copy an image from a folder location and paste it into a mail (outlook).
I don't want the image to be added as an attachment.
View 9 Replies
View Related
Oct 27, 2008
I'm using Excel 2003, Windows XP, and Microsoft Outlook. I'm trying to copy some cells, which include merged cells, from Excel into a new e-mail using Outlook (the output of some calculations), but every time I do this, Outlook seems to unmerge the cells.
When I paste into Word, the cells remain merged; I can then copy/paste from Word to Outlook with no unmerging occurring. what's going on and/or how to resolve this issue so I can copy things into Outlook straight from Excel?
View 3 Replies
View Related
Jul 6, 2012
I have a spreadsheet with client names, email addresses, and appointment info. I export a .csv file from outlook. I have been doing a mail merge in word and then coping and pasting into an Outlook message and sending it out. I did some reseach and found code that I have made changes to. Of course they it doesn't work. I can't get anything to happen when I run this code.
Code:
Sub Qualls_Email_Confirms()
Dim OutApp As Object
Dim OutMail As Object
Dim cell As Range
Application.ScreenUpdating = False
Set OutApp = CreateObject("Outlook.Application")
[Code] .........
View 3 Replies
View Related
Nov 11, 2009
I have a workbook that has multiple worksheets and I would like to use a command button to e-mail just one selected sheet. I want to create the single sheet as an attachment on a new e-mail message but leave the addressing to the user as it will vary, and not save the single sheet. My challenge is that the users have a variety of different e-mail clients (Outlook, Lotus Notes and others).
View 2 Replies
View Related
Sep 15, 2014
Code to copy the sheet that get selected by if-then-elseif statement and paste in a new workbook, save the workbook as temp, email it and delete it,
sub sending_mail
Dim OutApp As Object
Dim OutMail As Object
Dim rng As Range
Dim DataWB As Worksheet
[Code] ......
View 2 Replies
View Related
Mar 11, 2014
I am trying to write a macro to send mail on every Friday and also on last day of every month. If the last day of the month falls on Saturday or Sunday then the macro should mail on Friday. I have written a separate macro to send a mail. I have also written to check day(ie Monday, Tuesday etc) of today. If today is Friday or month end i can send mail. I dont know how to tell the macro to send mail on friday if the month last date is saturday or sunday.
Sub done()
Dim Dat As Date, x As Integer, y As Date, sorry As String
Dim str As String
sorry = "Today is not friday or month end. So i cannot send mails"
str = WeekdayName(Weekday(Now()))
[Code] ........
View 1 Replies
View Related
Nov 2, 2009
i'm trying to automatically create hyperlinks in some cells from mail addresses located in another column. this is what came out:
View 2 Replies
View Related
Aug 11, 2014
I've got the following code and have been trying to make the cells in column 1 align TOP LEFT but haven't been able to.
[Code] .......
View 2 Replies
View Related
Feb 26, 2009
I have a VBA module that performs several things when a command button is clicked. One of the last things it does is paste values, so when the module is comeplete the pasted area is still copied to the clipboard; in other words, it is outlined in pulsating dashes. What can i add to the end of the code to un-copy this selection?
View 2 Replies
View Related
Aug 13, 2009
1. I want to highlight cells on a form so that a user knows which cells to fill out.
2. When they print the form I do not want the cell shading to print.
View 2 Replies
View Related
Sep 27, 2006
I am trying to write a macro which highlights all the cells with any reference to other cell. The macro should highlight a cell with formula like = 3 * A25 but not highlight a cell with following formula. = 3 * 0.4535566. 'Hasformula' property is not useful here as it can't distinguish between above examples.
View 3 Replies
View Related
Dec 24, 2008
Macro copy & paste highlight. I HAVE THIS CODE
View 4 Replies
View Related
Dec 6, 2006
I have a lottery pool in sheet 1 in which i have the names of the people and their number picks. In sheet 2 i have the lottery results.
All i want is to be able to highlite(adding a backround color in the cell) to the matching numbers in sheet 1.
View 9 Replies
View Related
Feb 14, 2013
I am running a macro to make some changes to certain cells in a spreadsheet (formula changes)
Is there a code I can include within the macro so that all cells that change are also highlighted in yellow?
View 5 Replies
View Related
Jun 15, 2013
I have data in cells that are separated by pipe characters. What I need to do is to highlight the cells that are not the same. For instance, if a cell contains xxx|xxx then the cell is not highlighted but if a cell contains mmm|mmm|xx then the cell needs to be highlighted.
Sheet1 A1xxx|xxx2rrr|rrr|rrr3ttt|ppp4OO|OO|OOO5zz|zz|zz|tz6aaaaa|aaaaa7jj|jj|jj|jj|jj|jj8yy|yy9ww|tf|mz
View 6 Replies
View Related
Nov 16, 2007
I have a workbook and trying to copy all the way down the workbook using F4 blanks etc. When I highlight the column I want to fill in its not highlighting all the cells.
View 9 Replies
View Related
Aug 25, 2008
I have a spreadsheet that I need a m acro for, that will look at cell C13, if it is a 0 (zero) then hightlight cell C1 yellow. And so on, if C14 is zero, highlight C2..
Also look at the cells below,
cell D13, if it is a 0 (zero) then hightlight cell D1 yellow. And so on, if D14 is zero, highlight D2..
View 9 Replies
View Related
Dec 4, 2013
I'm after a formula (or similar) that if cell H1 has no data in then cells A1:G1 must be highlighted in a colour, considering A1:G1 has data in. And then when data is input into cell H1 then the highlight disappears. is this possible?
View 8 Replies
View Related
Mar 12, 2014
I am trying to create a special workbook for my asphalt project. After inputting all of the day's truck information, I want to add up the total tons and then for the program to highlight which truck puts the total tonnage at or slightly above 500 tons. I'm not sure if "isolating is the right term to describe what I wish to do or not, but my whole workbook will be based off of similar actions like what I'm requesting. Here is a portion of my sheet:
Truck #Tonnage
1 21.93
2 22.84
3 23.21
4 24.89
5 24.8
6 25.01
7 24.88
8 24.44
9 23.14
10 24.53
11 22.03
12 22.61
13 24.9
14 24.69
15 24.85
16 24.81
17 24.82
18 22.55
19 22.18
20 24.52
21 22.49
22 24.81
And so on.....
View 4 Replies
View Related
May 16, 2014
I have a sheet that I have item numbers in a column that i want to highlight and change color when they are not the same. I want the colors to be unique to each number. I am currently using conditional formatting (Format cells based on their values (3-color scale)). I works alright but not perfect.
condition formatting.PNG
View 2 Replies
View Related
Mar 19, 2008
Is there a way that when a cell is selected it will highlight the cell and all of the cells along the same row?
View 12 Replies
View Related
Sep 1, 2009
I am still new to VBA. I am trying to use VBA to search given rows for percentages above 0.81%. When it finds cells with percentages 0.81 and above it will high light the cell with red.
Here is what I have done so far ...
View 12 Replies
View Related
Mar 14, 2012
How do you highlight a row when conditions in two cells of that row are met? For example, I have a spreadsheet with a STATUS column ($A) and a TYPE column ($E). When the status is "open" and the type is "1", I want the row to be green. But when the status changes to "closed" I want the row to be a different color or no color at all. How do I do this?
View 3 Replies
View Related
Mar 26, 2014
I need to figure out how to have the macro look for a specific word and then highlight the last two columns in that row of that word and then repeat the process throughout the spreadsheet. I think it gets me very close to what I'm looking for: ('average of submitttocomplete' is the word i'm looking for)
Dim lColumn As Long
lColumn = Cells(Selection.Row, Columns.Count).End(xlToLeft).Column
Range(Cells(Selection.Row, Selection.Column), Cells(Selection.Row, lColumn)).Select
[Code]...
View 4 Replies
View Related
Jul 16, 2007
=IF(AND($P2="Yes",COUNTIF($L:$L,L2)>1,$Y2="Market Specific"),TRUE,FALSE)
But it is not doing exactly what I want it to, and I am struggling to work out what I need to change to get it to do so.
I want the formula to do is look at a three Columns of data, and to highlight Cells in Column Y when the following criteria are met:
The Row is active (determined by the "Yes" part), that the Row is "Market Specific" and that there is more than one Row where these Criteria are met (this is where I thought COUNTIF would work, but it's not).
View 9 Replies
View Related
Oct 13, 2008
I am trying to use a button, that when pressed it highlights certain cells in a row
I have the following code
Sub HiLite()
With Range("C20:Q20")
.FormatConditions.Delete
If Range("C20").Interior.ColorIndex = 3 Then
.Interior.ColorIndex = xlNone
Else
.Interior.ColorIndex = 3
End If
End With
End Sub
This works fine, but when i press the button again it clears the highlighted cells back to normal but any highlighted text etc or conditional formatting is deleted
Is there a way of returning to what was there before the first press of the button?
Just incase it is pressed accidently etc, as there will be many rows with the same button
View 9 Replies
View Related
Nov 6, 2008
I am trying to figure out how to highlight the row of cells within the column that contains the same date as the date in cell e:1 the date in cell e:1 changes daily because the formula says =today(). With that said, the column contains every date of the year so i would just like to be able to have the row, that contains the same date as the date in cell e:1, highlighted AUTOMATICALLY.
View 9 Replies
View Related
