Over 1 million tech questions and answers.

Email sending from Excel programming

Q: Email sending from Excel programming

Hello All techies here,

I am very much new to this forum.I am aware that it is possible to send emails from Excel using VB programming but I am very much unaware of VB programming and tricks.

I am working on a work where I need to generate automated mails from excel via outlook based on the contents of the selected cell and some logics.

Here is the URL for image that will give some rough idea.

https://fbcdn-sphotos-d-a.akamaihd.net/hphotos-ak-snc7/s480x480/391681_552548121437857_52068638_n.jpg

or
https://fbcdn-sphotos-d-a.akamaihd....480x480/391681_552548121437857_52068638_n.jpg

or

from this sheet(shown in image) I want to generate mail with logic like this :
case 1) If i click on MSS in row ABC ,click on APD and then press " @ " then it should generate a mail like below and send it to [email protected] and cc : [email protected]

subject : "card request"

mail body
**********
Hello,

My name is ABC (i.e. A2 content).
I need to have some MSS card of APD type
value 1
value 2
value 3
if above cards are not present then we can also use VD
value 4
value 5
value 6

Regards,
Shashank1320
*************

case 2 )but if I press MCS in row ABC ,APD and then press @ then it should send mail to [email protected] and cc : [email protected]

subject : card request
mail body
*****
Hello,

My name is ABC (i.e. A2 content).

I need to have some MCS card of APD type
value 1
value 2
value 3

if above cards are not present then we can also use VD
value 4
value 5
value 6

Regards,
Shashank1320
****
case 3)
if I click on MSS ,VD and then press @ then its it should send mail to [email protected] and cc : [email protected]

subject : " card request "

mail body
*****
Hello,

I need some MSS card of VD type
value 4
value 5
value 6

Regards,
Shashank1320
*****
same goes with row XYZ and PQR.
@ in row ABC will send mail to [email protected] cc to [email protected]
@ in row XYZ will send mail to [email protected] cc to [email protected]
@ in row PQR will send mail to [email protected] cc to [email protected]

One important thing to note :
either of MSS or MCS will be used to generate the email for required type.and it should be generating the mail for based on 3 things MSS/MCS , APD/VD and @.
Also MSS values are
value 1 :1011
value 2 :1012
value 3 :1013

Value 4 :1014
value 5 :1015
value 6 :1016

MCS Values are
value 1 :2011
value 2 :2012
value 3 :2013

Value 4 :2014
value 5 :2015
value 6 :2016

I know it will be a logic defined for the cells Type1,type2,card1,card2 and generate mail and whole thing will work only by clicking these 5 cells in a row.
I tried very basic VB ,it worked but I cant event think for this high funda logic.

I am using office 2007 at home on my laptop and using 2003 in office workstation.(mainly the tool will be used on office workstation only)

I really appriciate all your help and suggestions.
Thank you in advance.

RELEVANCY SCORE 200
Preferred Solution: Email sending from Excel programming

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: Email sending from Excel programming

Welcome to the forum,
I suggest you do a search for similar posts, give or take minor differences they all come down to the same solution.
Once you've found something taka a look and try it out.

Read other 3 answers
RELEVANCY SCORE 66.4

I like another previous member cannot send straight from an excel spreadsheet. However, mine says that no email exists. Any suggestions or comments would be appreciated.

Thanks Christina
 

A:help with sending an email from excel

HI,

Check this site.
http://www.rondebruin.nl/sendmail.htm
 

Read other 2 answers
RELEVANCY SCORE 66.4

A while ago, OBP helped me create an excel sheet that automatically sends me an email when a cell displays "send". Lately it has been sending an email regardless of whether the cell displays send. It's also not displaying the "action required" in the email. I was hoping someone could point out what's wrong as I messed with the visual basic language too much. I was also hoping someone could tell me whether I could use a button control instead of the macro firing whenever the file is opened.

thanks
 

Read other answers
RELEVANCY SCORE 66

Hi Guys,

I'm new on the forum so wanted to firstly say a quick Hi!!
But I wonder if you can help as I just cant get an issue solved and I'm sure you wizards of the Excel world can help me.
I am trying to get a spreadsheet to send automated email based on a trigger to say If todays date is within 7 days of the due date Then email a list of people in recorded another cell range

I found the following thread which looks really useful but I am getting constant errors when I try to apply the principle to my sheet.
https://forums.techguy.org/threads/...ue-date-reminder-based-on-excel-file.1129238/

I have table which starts in Cell B3.. (Headings in row 2)
Column A is Blank
Column B is Date Raised - this isnt used for anything
Column C is the Topic Of Work
Column D is the Notes from the meeting
Column E is the names of who the topics are assigned to
Column F contains the list of Email address to send that topic to
Column G is the due date (which I want to email out 7 days prior to)
and Column H is where the macro should make that it has sent the emails

The code I have tried is as follows... but I continually get a "Subscript out of range error"
Sub eMail()
Dim lRow As Integer
Dim i As Integer
Dim toDate As Date
Dim toList As String
Dim eSubject As String
Dim eBody As String
With Application
.ScreenUpdating = False
.EnableEvents = False
.DisplayAlerts = False
End With
Sheets(OpenActions).Select
lRow = Cells(Rows.Count, 2).End(xlUp).Row
For i = 3 To lRow
toDate... Read more

Read other answers
RELEVANCY SCORE 66

Hey All
Im very new to VBA, two weeks in the learning. I am trying to set it up so that when a cell on row g (sheet2) states YES. An single email is sent out to an address stated on sheet(1). Problem im getting is im recieving 80 emails. And none of Row g on sheet 2 is stating yes. Also can someone tell me how to make it send only a single email if more then one cell states yes.

Im bad at explain so please ask what every detail that may be needed.
Regards
Jimmy
Code:
Sub eMail()
Dim lRow As Integer
Dim i As Integer
Dim toDate As Date
Dim toList As String
Dim eSubject As String
Dim eBody As String
With Application
.ScreenUpdating = False
.EnableEvents = False
.DisplayAlerts = False
End With
Dim wa As Worksheet
For Each ws In ActiveWorkbook.Worksheets
If ws.Name <> "One" Or ws.Name <> "two" Then
lRow = Cells(Rows.Count, 4).End(xlUp).Row
For i = 2 To lRow
If Sheets(2).Cells(i, 7) = "Yes" Then
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)
toList = Sheets(1).Range("G14")
toAlso = Sheets(1).Range("G15")
eSubject = "Reviews/actions"
eBody = "Dear Sir" & vbCrLf & vbCrLf & "You currently have actions/reviews required on assessments on the following."
On Error Resume Next
With OutMail
.To = toList
.CC = toAlso
.BCC = ""
... Read more

Read other answers
RELEVANCY SCORE 66

I have a worksheet that I'm working on for work. It shows a list of trucks with different insurances and expiration dates. I'm far from savvy using excel and I need help creating a code that will alert myself and one other person if a trucks insurance is about to expire.
 

A:Sending an email with outlook through excel

Hi there, welcome to the board!

So, this is a loaded question. Let's first get all the information out on the table, then we'll be able to give you directions on how to best solve this.

See if I understand this correctly. You have a spreadsheet. This spreadsheet is located on your desktop computer. In this workbook you have a worksheet which contains data. The data is a list of trucks in some range (not yet specified), difference insurance information (not specified) and their expiration dates (in a range not yet specified). So from this we don't know the workbook name, worksheet name, data range where this data lies, nor a sample of the data housed in this mysterious range. In not trying to go overboard, can you please give us some specifics about this missing information?

Once we know the above information we'll know where we're starting from. This is only half the equation. The other half is what you actually want done. Also, this second part is easier if you fully define the first part. In other words, to properly describe an end point (e.g. solution) it's best to have a well documented/defined starting point (e.g. problem).

Let's say, for arguments sake (since we're not very well defined at the moment), that what you're looking for in a solution is to notify you + 1 other in the event of these expiration dates coming close to the current system date. Some questions I would ask is:

When should this list of expiration dat... Read more

Read other 1 answers
RELEVANCY SCORE 65.2

Hi all,

I am looking for help on VB script to send automated emails based on the dated column in excel sheet..
I need to send reminders to the email addresses in Column J & K to remind them that the vehicle registration in Column B is due an MOT on the date in Column M, also to send a reminder that the Tax is due on the date in Column P. these emails need to be sent 14 days before the due dates.
I also require Column N & Q to generate at date and time when the reminder was sent.
I would much appreciate any help with this as I am completely new to VB script, I have attached the file to aid in any help
 

A:Sending Email reminders from excel to outlook using VBA

Read other 11 answers
RELEVANCY SCORE 65.2

Hi is there a way to send an automatic email of a workbook on a certain date?

For example workbook 1 needs to be sent at the end of every month automatically when opened.

thanks
 

A:sending excel sheet via email autmatically

"the end of every month"

Is that the last day or the last working day? If the latter, define "working".

The Analysis Toolpak add-in (you'd have to check if you have it installed) has some useful additional functions, such as EOMONTH.

Today (20th March), the formula:

=NETWORKDAYS(TODAY(),EOMONTH(TODAY(),0))

returns 8. That probably means that there are 8 working days left this month, including today. Of course, this month is a bad example because of Easter; NETWORKDAYS' 3rd argument "Holidays" is something you'd have to plug in.

Some very basic "workbook open" code could check the value of such as formula and act accordingly (i.e. if formula result = 1, do x-y-z). You might also need to set a flag to handle the workbook being opened > once on the "last" day.

Beyond that (or maybe even instead of), Ron de Bruin has lots of snazzy SendMail stuff.

HTH
 

Read other 2 answers
RELEVANCY SCORE 65.2

Good Day,

I would like assistance in creating a code that will generate a automated email to specified receipients when a date is entered into a specific cell. I have attached a sample spreadsheet. When a "date" is added in column M, it automatically generates a email to specific recepients notifying the receipients that the specific unit number in column A has been completed.

For Example:

Good Day,

This is to notify you that unit *** (from colum A) is complete and ready for your team.

Thank You,

xxxx

Thank you very much for the assistance!
 

A:Solved: Sending a Automated Email Through Excel

Read other 8 answers
RELEVANCY SCORE 65.2

Hi!
I am using Excel to track many IP deliverables for a project. almost 100 IP's
In the excel I have Initial/current/Acutal/date of IP delivery.
Based on the Aligned(Actual) IP delivery scheduled date, I am looking at how to automatically send Email reminder to the IP Provider on or before the aligned from Excel.
Please do let me know how I can acheive this automation.

Thanks
Nagesh
 

A:Sending Email Reminders to Different people from Excel

Read other 16 answers
RELEVANCY SCORE 65.2

Hello,
I have a excel through which I track the delivery schedules of a large number of IP's for a design.
I looking how I can automate in excel to send reminders to the IP Providers.
Based on the Actual delivery date, I need to automate the excel to send out reminders.
Please let me know how I can do this. If you need to look at the excel, I can send it.
Thanks
Nagesh
 

A:Sending Email Reminders to Different people from Excel

Hi Nagesh!
Wy did U put the same thread twice!
 

Read other 2 answers
RELEVANCY SCORE 65.2

Hi all,

I have a question,
I use the following code to send a Excel workbook via Email.
Code:

Private Sub Mail_workbook_1_Click()
'Working in 97-2010
Dim wb As Workbook
Dim I As Long

Set wb = ActiveWorkbook

If Val(Application.Version) >= 12 Then
If wb.FileFormat = 51 And wb.HasVBProject = True Then
MsgBox "There is VBA code in this xlsx file, there will" & vbNewLine & _
"be no VBA code in the file you send. Save the" & vbNewLine & _
"file first as xlsm and then try the macro again.", vbInformation
Exit Sub
End If
End If

On Error Resume Next
For I = 1 To 3
wb.SendMail "[email protected]", _
"Subject"
If Err.Number = 0 Then Exit For
Next I
On Error GoTo 0
End Sub
It does the trick for so far, but it sends the e-mail directly, without showing the E-mail itself first (only a notifications shows up which tells you some program is trying to send an email).
I would like to manually select Send in the E-mailmessage, so our customers are sure that the e-mail is send correctly.

How do I change this?

An other question, the Subject of the message is now "Subject" how could I 'attach' a value from cell B9 to it?

It would be pretty simple I guess, but I can't find the answers.

And last and also least important.. It isn't poss... Read more

A:Solved: Excel; First show Email before sending

Read other 7 answers
RELEVANCY SCORE 65.2

Microsoft excel 2003 (as part of microsoft office 2003 small business edition), on XP professional 2002 service pack 3.

I have a spreadsheet on which it looks as though I must have pressed "send to mail recipient", by mistake, because it now always displays with the fields "To:" etc, using up several lines. How do I get rid of all that? I can't find a cancel facility. One option I suppose would be just to send it to myself, but that would involve setting up outlook, and I don't know how to do that, given than I only ever use webmail (googlemail as it happens). I did just try setting it up with completely fictitious info, but it was too clever for me, and recognised that it couldn't achieve sending that way, so kept displaying all the stuff I don't want.
 

A:Solved: excel: cancelling sending by email

Read other 6 answers
RELEVANCY SCORE 64.4

Hi, I have a risk register which has action by dates for owners of that particular risk. I would like to set up a VBA code that automatically sends each owner an email reminder, through outlook, 5 days before the action date. One owner may have multiple risks due on the same date so I would like the code to send 1 email detailing all the item numbers that the owner has to look at (however this is not at the top of my requirements if it causes issues). I would like the email to include the "Number" (Col. A) in the body listing which risks the owner should look at along with a message reminding them that the action by date is near. Also i want this to be automated, I want the code to run once and send emails as time goes on. Also i will need to change the action by dates as new information is available, can the code account for this change and send another email when the new action by date is near? Thanks for your help I really appreciate it. Using excel 2010
 

A:Excel sending automatic email to owners near due dates

Read other 12 answers
RELEVANCY SCORE 64.4

Greetings all,
I am a novice at best on using excel, but through some searching and experimentation I have managed to get to a roadblock I cannot pass. I am working on setting up a workbook that emails at specific dates for reminders to people in my department. I believed I had it working however I have run into two issues.
One is a run type error 13 that highlights toDate = Replace(Cells(i, 3), ".", "/") when I run the debug.

The second is that no matter what I try to do I continue to receive error messages. Can I ask that one of the very talented excel knowledgeable people here look to find where I am making my errors?
Thank you much in advance with any assistance you can provide which will stop me from pulling out my hair.
 

Read other answers
RELEVANCY SCORE 64.4

Hello,

I will be grateful if you can please help me have automation in the attached Excel sheet for automatically generating and sending (triggering) Emails to the action owners based on their Email IDs upon approaching of "Actual Finish Date (column I) in the attached Excel sheet? My request is similar to https://forums.techguy.org/threads/excel-sending-automatic-email-to-owners-near-due-dates.1171902/.

You are welcome to suggest and implement value additions.

It will be a boon if this task can be accomplished irrespective of any Email client. Be it Microsoft Outlook or Lotus Notes. Please help.

Regards,
Maitreya Barve.
 

Read other answers
RELEVANCY SCORE 63.2

Hi All!

I am having major difficulty figuring out excel. I am using a spreadsheet and want excel to automatically send an email to the user in that row when a contract is expiring. Within the row I have the specified user's email, the end date of the contract, and when the reminder email should go out. I have tried playing around with Macros and VBA coding, but I have no idea what I am doing. I am using excel 2003. Any help would be greatly appreciated!! I am using Outlook as my email. Have questions please let me know!

-J
 

A:Email automatically sending to user when cell is at a certain Date Excel 2003

Read other 16 answers
RELEVANCY SCORE 55.2

I use Outlook for email, from Office 2007 Professional because the accounting program and my Palm Pro PDA likes it.

Just recently I have had a couple of complaints that emails with a video attached I have forwarded have been delivered to the addressee in excess of 30 or 40 times.

The latest was last night when one of my sons said he had received it 104 times, and another friend in the USA 99 times, needless to say both aren't happy, the video was a wmv (3mb).

When my son called me a an hour or so later it was still in my outgoing mail box, obviously because it was still sending.

I have run full AV scan using Esset Nod32 which came up clean, so I&#8217;m at a loss where else the problem is or where/what to look for.

Thanks for reading&#8230;..Any clues/help would be appreciated.
 

Read other answers
RELEVANCY SCORE 54

I was asked to make a program using excel for the main purpose of managing shares, stocks, investments and others. That's why I am looking for good tutorials for excel programming, for this will be my first time doing something of the sort.
If any1 could give good recomendations and/or tips, it would be fantastic.
Thanks in advance guys. As usual, life savers ;)

Just noticed that Excel Programming is VB. So also comments on this area would be helpful.

A:Excel Programming

Are you asking how to set up a spreadsheet to "manage" investments, or perhaps about Macros to automate the process? I think it would help us if you could clarify what you expect the spreadsheet to do.
Thanks,
John

Read other 5 answers
RELEVANCY SCORE 54

Say, for example, I have a list of interest rates and the more people I sign up to my program, the higher my interest rate is. The time money would be invest for, is on the left-hand side, and the amount of people signed up is on the top.The items listed down on the left-hand side are as follows:~ Weekly~ Fortnightly~ Monthly~ 2 Months~ 3 MonthsThe top of the cells are from 1 - 10.The interest increase both as they go down, and across to the right.My question about this, is if I were to have a different table, and in that table I have people who sign up people, and I have (I have cell referenced each part)A1 - NameA2 - People signed upA3 - Interest rateB1 - JohnB2 - 3B3 - (the interest rate)C1 - AimeeC2 - 7C3 - (the interest rate)I was to know that from the first table set up, how can I get Column 3 to represent the cell from the amount of people that have signed up. So, that in Column 3, the interest rate that is shown is from the first table, and gets the amount of interest from the people signed up.No, it's not just simple "cell referencing" because I want the interest rate to be based on both the, time period, and how many people signed up, and I want it to be automatic instead of me doing it manually.Is it possible?NOTE: Here is a perfect example of what I want to achieve, just some things change.

A:Excel Programming?

I'm not an Excel guru but I'm sure that you could make something work with either a combination of VLookup and HLookup or just Hlookup and an if statement.Here's a pretty good link on embedded vlookups. hlookups work the same way except it searches by the row rather than a column.http://pubs.logicalexpressions.com/Pub0009...icle.asp?ID=446

Read other 2 answers
RELEVANCY SCORE 54

I was just wondering if anyone could help me with writing a macro in excel. I am fairly new to VBA. I am trying to set up a Macro that will chart data and display values above a target line green and values below the target line red. If anyone can help me with this that would be great!

Thanks,
Matt
 

A:VBA programming on excel

Hi cub18,

Welcome to the forums.

Plenty of people will help you on here, but you need to give a bit more information, and an attached spreadsheet is always a great benefit when attempting to solve issues like this.

It sounds like you just need to use conditional formatting, but again it depends on the details.
 

Read other 3 answers
RELEVANCY SCORE 54

I am trying to change the D53 cell reference in this statement to a variable defined as integer, without success. I would be willing to change the whole range definition to a variable if necessary. Any suggestions would be appreciated!!

ActiveChart.SetSourceData Source:=Sheets("WorkSheet").Range("A29:d53"), _
PlotBy:=xlColumns
 

A:Excel VB Programming

Welcome to the board, Bob W.

Where will the values come from?

x = Application.InputBox("How many rows?", "Size chart range")
y = Application.InputBox("How many columns?", "Size chart range", 4)
ActiveChart.SetSourceData Source:=Sheets("WorkSheet").Range("A29").Resize(x, y), _
PlotBy:=xlColumns

, perhaps.

HTH,
bomb
 

Read other 1 answers
RELEVANCY SCORE 54

Hi

Id like to set Toggle Button 1:

When Value to show Cell A1
Else, cell 1 to be hidden.

Advice please!

Thanks!

M
 

Read other answers
RELEVANCY SCORE 53.2

Hi Guys,

Let me start off by stating that I'm still trying to learn all the juicy functions you can do with Excel, and I've just gotten myself a little project where I think I can learn but I need some kind of help from you guys.

Basically what I'm trying to do is somehow automate a creation of a report via excel, first method I thought of was to use macros, but since the data that'll be included in the report will be on a different cell each time, macro might not work as I imagined it to be, then I thought of the IF function, I have not yet tried doing that, but would that work? Can you please share your thoughts? Ask me any additional info and i'll try to explain it as simple as I can.

Cheers.

A:[HELP] Programming in Excel 2013

Your description is entirely too vague in order for anyone to offer any kind of help. Can you be more specific as to what kind of a report you want to generate and what data you will be using?

Perhaps you could post a sample of the worksheet with the data and a sample of what you want the report to look like.

Read other 2 answers
RELEVANCY SCORE 53.2

I am writing a food costing program in excel to calculate a number of costs, conversions etc. in Microsoft Excel. I have my code working to what I would like it to do but I have hit one snag. I want to be able to copy and paste the code throughout the spreadsheet and I need certain values to remain the same and some to change accordingly.=LOOKUP(A13,Centennial!A6:Centennial!A26,Centennial!E6:Centennial!E26) that is the code and I need the values of the ranges to stay the same(A6,A26,E6,E26) and A13 to change as i copy and paste. How do I keep those values constant?
 

A:Excel Programming Constant Value

use a $ sign to fix the position

A6

to keep the column from changing type

$A6

to stop the row changing type

A$6

to fix both column and row

$A$6

so for your look up range

$A$6.$A$26
 

Read other 3 answers
RELEVANCY SCORE 53.2

I have two spreadsheets; the first has two columns, UPC and ITEM; the second has many columns of which UPC is one. I need to create a lookup function or something that will insert the value of ITEM from the first spreadshet into a new column I will create in the second spreadsheet based on the UPC matching. I prefer to use Access for these situations but I don't want to do that with this data. Is this easy to do?
 

A:Excel LOOKUP Programming

Yes. Give me 5 minutes & I'll post a formula. Or does it have to be "programming"?
 

Read other 3 answers
RELEVANCY SCORE 53.2

I want to use MS Excel for keep records of a warehouse. I have created an invoice with necessary formulas and it automatically calculates everything, writes the final total in words. Now I want to connect this invoice with a warehouse record to automatically keep records of invoices issued and to automatically reduce the quantity of goods from the warehouse. This should help me to find the availability of goods at the warehouse at any given time and also to see the sales progress.
The problem is I don't know the formulas to be used for this type of programming.
Please help me with some idea about the formulas to be used.
Thank you.
 

A:Microsoft Excel programming

Read other 11 answers
RELEVANCY SCORE 53.2

Anybody know how to format a cell like this?

I would like my cell to total up a bunch of items, much like the Epsilon (at sum), but then I want the display font to be blue when it is positive, and then red when it is negative.

Thank you.

------------------
"There are no stupid questions, just stupid people." -- Mr. Garrison on South Park
 

A:Excel Programming... or formatting

Highlight the cell, rows or columns you want formatted. On the Menu-Format>Conditional Formatting. Using the
Cell is: Greater than: 0 and
Cell is: Less than: 0
and specifing the patterns or font you want for each particular scenario should get you what you want.

The above uses two Conditional Formats you may be able to get your conditions set up using only one box. It also leaves 0 without a format so you may want it to be inclusive on the negative or positive result.

 

Read other 3 answers
RELEVANCY SCORE 53.2

when i try to make an vba code in excel vba extension at the moment i added
this line to the code of a button:

Range("A1").End(xlDown).Offset(1, 0).Select
it says there is an error but i did exactly what they said on this video
https://www.youtube.com/watch?v=CzP8nO9UVvY
its explained just after 25:12 minutes

A:excel vba programming code

I tried the code and it works without errors. Are you sure it's that line it complains about?

This shorter one works to: Range("A1").End(xlDown).Select

Read other 9 answers
RELEVANCY SCORE 52.8

Hello to the members of Tech Support. This is my first post, so thanks in advance for the help! So here is goes.

-I have 9 worksheets with approximately 77500 rows and 23 columns of data between all nine.
-At the top of the worksheet I have a table data running from E7 to N7. This data is carried over from the previous month's data.
-Column AA has a formula: =Z13+(O13-Q13)*3340.4
Where Z13 is the first row where the data begins, and Z### is where the data ends. Rows of data vary from month to month. The formula carries on such that row 14 uses the same formula but insert 14 vice 13. The number 3340.4 is the number found in cell E7 and always the multiplier in the formula.
-Column AA on worksheet 2 requires the same formula. =Z13+(O13-Q13)*4567.3. However note that the 4567.3 is the next number over in cell F7 and is now the multiplier until the last row.
-Worksheet 2 has a different number of rows (which also varies from month to month.).
-The data for each month is always found in cells E7-N7.

Worksheet 3 would use date in G7 and so on....

Any help with the coding of this Macro would be greatly appreciated.
Thanks
Can someone help me with the macro to automatically
 

Read other answers
RELEVANCY SCORE 52.8

Since we all type in our email addresses many times a day, it would be convenient to assign F12 with the address. Is this possible?

A:Programming F12 with an email address

Is this for web forms or Windows applications?

Read other 4 answers
RELEVANCY SCORE 52.4

Hi,l

My antivirus software is showing that I'm sending email that I'm not sending! I don't even know where it is sending from. And it is yucky SPAM headlines that it looks like it is sending. I use AVAST anitvirus. I'm on a wireless laptop running xp home. Microsoft outlook express and hotmail and gmail are the email accounts that I use.

What to do?
 

A:hijacked: sending email that I'm not sending

Read other 16 answers
RELEVANCY SCORE 52

hi to all,

i'm writting a marco to populate the row and col in the spreadsheet. I provide an form interface for the user to key in the data before reflect the data in the spreadsheet. my question is how do i detect the first blank row and transfer the data into that blank row in the spreadsheet.

i only have 9 columns and therefore i hardcode the colum, however, i need to find the blank rows so as to insert the data.

Cells(currentRow, 1) = txtTime.Text
Cells(currentRow, 1) = txtDate.Text

can someone tell me how to fiind the index of the rows???????

Thank in advance
 

A:excel marco programming detecting blank row

The code you have writes txtTime and txtDate to the same cell. Try:

newrow = Range("A65536").End(xlUp).Row + 1
Cells(newrow, 1) = txtTime.Text
Cells(newrow, 2) = txtDate.Text

, assuming you have at least one row already.

I couldn't tell you what data type to use for newrow. Zack could tho', he might drop by later.

HTH,
bomb
 

Read other 3 answers
RELEVANCY SCORE 52

Question to the group:
I do a lot of intensive VBA programming within MS Access (2003 and 2010) for clients and have always programmed on PC platforms within Windows 2000, XP, 7 operating systems. Everything's worked just great. No problems.
I recently purchased a MacBook Pro and had Windows 7 installed on Bootcamp. I've installed MS Office 2010 and the installations are all humming along nicely and everyone seems to be playing well together.
My problem is that my existing Excel and Access applications that use VBA code generate boatloads of errors on the Mac platform (with Windows 7 running on Bootcamp). Attempts to program anything but the simplest VBA scripts also generate errors that do not appear on the PC platforms.
My questions are: Is this a problem with References or program/computer settings? Have other programmers tried to do the same thing I am doing and had the same problems? Is the Mac system simply incompatible with a Bootcamp/Windows/Office/VBA layering? Is there a solution? I can't find any other references to this problem in the searches I have performed so far. Any input would be appreciated.
Thanks in advance.
 

Read other answers
RELEVANCY SCORE 51.6

Hi there

I found an example on the internet on how to solve a linear programming problem using Excel 2000 Solver. I have attached a workbook with all the information you will need to solve the linear programming problem. I must be doing something wrong because my solution is different from the example I found on the internet. Here is the link to the internet example

http://www.ateneonline.it/chase2e/studenti/tn/6184-7_supA.pdf
 

Read other answers
RELEVANCY SCORE 51.6

I am writing a food costing program using excel. The program is designed to pull prices from various tabs(different suppliers) to a main Supplier Costing Page containing all the information on products for all suppliers. The code allows the user to enter in the name of the product, then uses the LOOKUP function to search for the product and returns the value in that row. The code I used to pull the information from the different suppliers works properly:

A19 value Steak Strip Loin C/C St. Silver FRSH

=LOOKUP(A19,Centennial!$A$6:Centennial!$A$100,Centennial!$R$6:Centennial!$R$100)

Centennial is the tab for that supplier. It pulls the correct value from the page 0.74, to cell R19
The problem I am having is that when I try to use this format of code on another tab it does not return the correct value:

=LOOKUP(A33,'Supplier Costing'!$A$6:'Supplier Costing'!$A$100,'Supplier Costing'!$R$6:'Supplier Costing'!$R$100)

The code should return the same value of the previous line of code as it is the same product:0.74 to cell R33 this time, however it returns the value of another product on the Supplier Costing tab. Is the LOOKUP function not searching the tab for the whole string? Any help or suggestions would be extremely helpfull. Thanks
 

A:Solved: Excel Programming Code Produces Wrong Value

Read other 12 answers
RELEVANCY SCORE 51.6

Excel 2016 Formulas is fully updated to cover all of the tips, tricks, and techniques you need to maximize the power of Excel 2016 through the use of formulas. This comprehensive Training Program explains how to create financial formulas, release the power of array formulas, develop custom worksheet functions with VBA, debug formulas, and much more. Whether you're a beginner, a power user, or somewhere in between this is your essential go-to for the latest on Excel formulas

Enrol This Course Now

PART=1
1. Workbooks (File) & Worksheet Handling
Excel Limitation

Excel Shortcut use and benefits

Excel Setting and Custom List Creation

Excel Tamplate and File Location System

Advanced Paste Special

Calulation with Paste Special

Link Data range as Picture Link

Loopkup Picture in Excel Worksheet

2. Advanced Formating for Reports and Dashboard
Formatting Triks

Date & Time For Trinks

Advanced Custom Formating (Number Format using Code)

Condtional Formatting

Advanced Conditional Formatting using Formulas

File,Sheets or Cells Protection Method

Benefits of Data Table or Cells Style

3. Data Handle and Data Analysis
Data Fill and Selection Method

Advanced Sorting and Filter Trinks

Data Summerization with Pivot Table

Calculation with Pivot table

Extranal Data Pivot Table

Relationship and Slicer in Pivot Table

Power Pivot in Excel 2016

Use SQL Query in Pivot Table

4. Page Setting and Form Creation
Drow Form in Excel Sheet

Hyperlink i... Read more

Read other answers
RELEVANCY SCORE 51.6

hello:
 
i have been trying to fix my email/outlook spam issue.  emails are going out WITH my actual email address, sending emails to people in my contacts, etc.
I also have been getting a ton of spam emails myself.
 
I use:
 
-Windows 7 Pro
-64 Bit
-Outlook 2010
-I have our own domain name email address, that is hosted by Frontier
 
Odd thing:  I changed my password for my email, but my outlook kept sending/receiving with the old password.
When I tried to update  the new password in outlook (which I verified by using the webmail versus outlook), it would not accept it.
 
Thank you for any help you can provide.

A:email / outlook is sending emails with my email address

Here is my FRST logs:
 
Scan result of Farbar Recovery Scan Tool (FRST) (x64) Version: 26-06-2016 02
Ran by LS (administrator) on LS-PC (27-06-2016 12:22:27)
Running from C:\Users\LS\Downloads
Loaded Profiles: LS (Available Profiles: LS)
Platform: Windows 7 Professional Service Pack 1 (X64) Language: English (United States)
Internet Explorer Version 11 (Default browser: Chrome)
Boot Mode: Normal
Tutorial for Farbar Recovery Scan Tool: http://www.geekstogo.com/forum/topic/335081-frst-tutorial-how-to-use-farbar-recovery-scan-tool/
 
==================== Processes (Whitelisted) =================
 
(If an entry is included in the fixlist, the process will be closed. The file will not be moved.)
 
(NVIDIA Corporation) C:\WINDOWS\System32\nvvsvc.exe
(NVIDIA Corporation) C:\Program Files (x86)\NVIDIA Corporation\3D Vision\nvSCPAPISvr.exe
(Realtek Semiconductor) C:\Program Files\Realtek\Audio\HDA\RtkAudioService64.exe
(Waves Audio Ltd.) C:\Program Files\Waves\MaxxAudio\WavesSysSvc64.exe
(NVIDIA Corporation) C:\Program Files\NVIDIA Corporation\Display\nvxdsync.exe
(NVIDIA Corporation) C:\WINDOWS\System32\nvvsvc.exe
(Realtek Semiconductor) C:\Program Files\Realtek\Audio\HDA\RAVBg64.exe
(Microsoft Corporation) C:\WINDOWS\System32\wlanext.exe
(Apple Inc.) C:\Program Files\Common Files\Apple\Mobile Device Support\AppleMobileDeviceService.exe
(Realtek Semiconductor Corporation) C:\Program Files (x86)\Realtek\Realtek Bluetooth\AvrcpService.exe
(Apple Inc.) C:\Program Fil... Read more

Read other 2 answers
RELEVANCY SCORE 51.6

Intermittently, Outlook 2007 will crash while sending an email and, needless to say, the email is not sent. However I wanted to know if there is a temp or backup copy of that mail anywhere. I've looked in drafts and it's not there.

I've sometimes typed a very long email and then lost the whole email when Outlook crashes so I just wanted to know if, like Word, there is a temp file that may be created.

Thanks.
 

A:Outlook 2007- crash while sending email - where does the email go?

Hi cp, welcome to TSG. Do you have Autosave enabled for Outlook? If not, perhaps this link will help.
 

Read other 2 answers
RELEVANCY SCORE 50.4

Good morning, people,

One of my users here is having a wierd issue with her Outlook program...Every time she sends an email out, a .txt file of that email is sent as an attachment to that email.

So an email saying, "Greetings!", has the text file attached that says, "Greetings!".

Any ideas?
 

A:Outlook sending a copy of email w/email

Must be set to send in both plain text and HTML? But I thought in that case that it was done the other way around...

Turn off one or the other in the E-mail options, would be my guess.
 

Read other 1 answers
RELEVANCY SCORE 48.8

"This is an automatically generated Delivery Status Notification.

Delivery to the following recipients failed"
I only get this when i send from my long time email address a msn.com one. I cant find where to check the pop settings on this laptop or dont even know if that would work. Can you help me understand why i cant send or reply from this one address of mine, all the others work fine. just this one email address of mine that has been mine from the beginning of internet in my life.
Thank You , Nancy

A:Email from one email account not sending

What are you using to manage email? . . Outlook Express? . . Outlook? . . Windows Mail??

Read other 19 answers
RELEVANCY SCORE 48.8

"This is an automatically generated Delivery Status Notification.

Delivery to the following recipients failed"
I only get this when i send from my long time email address a msn.com one. I cant find where to check the pop settings on this laptop or dont even know if that would work. Can you help me understand why i cant send or reply from this one address of mine, all the others work fine. just this one email address of mine that has been mine from the beginning of internet in my life.
Thank You , Nancy

A:Email from one email account not sending

What are you using to manage email? . . Outlook Express? . . Outlook? . . Windows Mail??

Read other 19 answers
RELEVANCY SCORE 48.8

hello everyone, i have created email form using incomediawebx5 software, i have uploaded the forum in my website,, all looks ok in my website, when someone/ or i try to send a email using email form just to check its working or not, after click send button, i recieve this message,
All data will be send to email [email protected] once the website is been loaded on server,

i dont know how to fix this can anyone help please
 

Read other answers
RELEVANCY SCORE 46.8

I know this may be an obvious question, but I have a number of Worksheets in my Excel Workbook.

How do I send just a single Worksheet via e-mail?
 

A:Sending Excel Worksheet

It's not obvious at all. Questions:

1. Always emailing to the same person?
2. Email as an attachment? Or as part of the message body in Outlook?
3. Want a button on the worksheet?

You can check here:
http://www.rondebruin.nl/sendmail.htm
 

Read other 3 answers
RELEVANCY SCORE 46.8

I have created an invoice using Office Excel.

As a test I sent it to own e-mail address.

The problem I have is when I received it, it was sent directly to my deleted folder.

I have both Norton Anti Virus and Internet Security installed on my PC.

Could these two programs have anything to do with it???

Thanks
 

A:Sending Excel Worksheet

Read other 8 answers
RELEVANCY SCORE 46.8

Hi all,
I am trying to write a spreadsheet to be distributed across a number of site. Once the info req. has been entered into the spread sheet, as the level of knowledge of the users will be negligable.

So I want to put a button, or a text box on the sheet that will save the file, open a mail, & attach the current file, simply leaving the user to click send. simply by clicking the button/text box.

I have set up a user file that opens a new mail, but thats as far as i've managed to get.

I can open the mail, but i can't find a way to attach the file. can anyone help.

Paul
 

Read other answers