“Reply To All” With Standard Answer In Outlook

Sep 23, 2007

I’m currently writing a code, which will enable me to run a code, which will reply to a selected email with standard text in the cc, subject, body, and so on.

The code that I managed to write creates a new email message, instead I want the code to select "reply to all" to the email that I’ve selected, and then fill in the cc, subject, body, and so on.



Sub test()
Dim msg As Outlook.MailItem
Set msg = Application.CreateItem(olMailItem)
msg.Display
msg.CC = "test@hotmail.com"
msg.Subject = "testing!"
msg.Body = "hello all" & vbNewLine & vbNewLine & "We agree to your call..."

End Sub

View 9 Replies


ADVERTISEMENT

Linking Outlook Standard Mail Format With Excel Hyperlink?

Jul 3, 2014

I have a standard mail format which was saved in my hard drive(mail includes attachments and few contents in body) via excel. I've several vendor (#)numbers in my excel sheet, everyday I've to send a mailer to different vendors with necessary documents.

1. Vendor number EX: 12345 was hyperlinked, when I click on that 12345 standard mail format should be opened in outlook and the Vendor number 12345 to copied as TO:12345 CC: defined names in the outlook mail.

View 5 Replies View Related

Message Box Reply

Jan 3, 2009

my message box reply.

In cell e14 I have the following formula =IF(D14

View 9 Replies View Related

Add Recipients To Reply All In Macro?

Apr 21, 2014

I have a macro which sends an excel file to certain recipients via outlook. I have embedded the voting buttons in the same macro. However, when I respond to the voting buttons, I am unable to add the sender and another group. The current macro .readrecipients, enables me to send it to the sender. I would like to add another group id to the same.

View 1 Replies View Related

Email: Reply To Address From VBA

Apr 28, 2009

I am currently trying to automate a receipt system. I have successfully managed to create an email based on calculated Excel data. The email is created using the following routine.


callref="12345"
strbody = "The main text of the email"

Set OutApp = CreateObject("Outlook.Application")
OutApp.Session.Logon
Set OutMail = OutApp.CreateItem(0)

On Error Resume Next
With OutMail
.To = "John Smith"
.BCC = ""
.Subject = "Test email receipt - " & callref
.Body = strbody
.Display 'or .Send - still developing!!!
End With
On Error GoTo 0

Set OutMail = Nothing
Set OutApp = Nothing

My problem is that there will be several people using this system so I would like to include a reply address which is different from the sender. Alternatively, I would like to send the email from a different account (but I have to assume that the users will have their own email accounts open).

View 9 Replies View Related

Automated Reply To Inactive Window

Jun 30, 2007

I am using PrimoPDF, as suggested elsewhere in the forum, to attach a PDF to an E:Mail and send it automatically, it works a treat ... however, I do have to manually intervene to click on the OK button & then again to click on YES when the filename is duplicate. I would like to automate these actions and am looking for a way to do it. It looked like the SendKeys command was perfect, but I'm not 100% sure how to do it. The PrimoPDF window is open, named as "PrimoPDF", but is not my active window, so I have put PrimoPDF.SendKeys "{Enter}"

... into the program but I am getting the error message "Run Time Error '424': Object required". Is this something to do with my code ? I am guessing that the program isn't recognising that PrimoPDF is an open & inactive window, so am I missing a prefix here or is it something more serious, like having to add a new Component or Additional Controls ?

View 3 Replies View Related

Option Of "SOLVED" On The Post Reply When You Are The Orginal Poster

Aug 20, 2009

Is there any way someone can put the option of "SOLVED" on the post reply when you are the orginal poster.

Now you have to reply to the post then go back into your orginal post to mark it solved. they would be more willing to mark the thread solved. I have noticed many people get an answer and never respond or mark solved.

View 2 Replies View Related

Same Formula, Why Can't Get The Same Answer??

Jun 4, 2009

in the "Order for EMS" and "Order for FEDEX" there have 1 product exist, now the customer need to type the country in the "F35", and the Price of weight will look back to the sheet "EMS Weight" and "FEDEX Weight" but for example, if i type Japan in both sheet, the EMS that one is correct 1kg to Japan is $168 but in FEDEX that one is not correct 1kg to Japan is $169 but now show $342, the formula in "G36" should be correct, what's wrong of my formula????

View 3 Replies View Related

IF Argument Need With Yes/no Answer

Nov 11, 2009

I have a sheet that has 2 fields that i need a yes/no answer from. Basically if b = "P1" then a should be less than or equal to 4 to reply good otherwise it should reply no. but if b isnt "P1" but instead is P2 P3 or P4 then it should => 10, 30, 40 respectively.

View 8 Replies View Related

Get An Answer Based On A Value?

Jan 1, 2010

I want to tell Excel that, if a cell value is between 1 and 100, to enter one result in another cell. If the value is between 101 and 250, enter another result in that same cell. If the value is between 251 and 500 enter another result in that same cell and so on about another 12 times.

View 5 Replies View Related

Open PoP Up With Answer

Oct 14, 2009

i just wanted to know if we can open a pop up which will give us answers. i have attached a example work sheet of what i require

View 3 Replies View Related

AutoSum: The Answer Should Be 8

Jul 3, 2009

I have a formula that is in ColF Row4, and it is copied down to ColF Row 13. But trouble is that when I autosum this column I get 6, but the answer should be 8.
The data in Rows A-E are extracted from an external data source. I've attached the spreadsheet. =IF((AND(A4=7,D4="")),1,(IF((OR(A4=7,D4>=2)),D4,0)))

View 4 Replies View Related

Text Box For Other Answer

May 24, 2008

I have to following code. I have an issue now where I have to Pop a textbox from based on the answer to one of my questions.

If cboProjOffset = "Other" Then
userSalOther.Show

Problem is I actually want the text box to populate on the same line of the range answer in column m. At present it doesnt seem to be doing this. Can anyone help?

Public gintEditMode As Boolean
Public gintTotalEntries As Integer
Public gintLineNumber As Integer
Private Sub cboProjOffset_Change()
If cboProjOffset = "Other" Then
userSalOther.Show
End If
End Sub

View 9 Replies View Related

Return Answer Dependant On /

Apr 5, 2009

in cell d1 i have

hk/q46559

in cell i1 i need to return whatever is before the "/"
in this case hk

and in cell i2 i need to return the number after the q
in this case 46559

View 3 Replies View Related

VBA To Automatically Answer Pop Up On Open.

Jan 11, 2010

I have a few 2007 workbooks that are set up to track and compare individual budgets over time. The majority of the cells are referencing workbooks that have yet to be created.

On opening these workbooks the users are confronted with an informational window informing them that "This workbook contains one or more links that cannot be updated", to which they are instructed to choose "Continue". Is there code I can add to these workbooks that would automatically choose "Continue" once a user enables the security warning for Automatic updates of links? I believe this would be the same as an On Open event.

View 7 Replies View Related

Answer Only If Greater Than A Number

Apr 12, 2013

How do you put an answer in a cell after subtracting 2 numbers and if greater than a number put that answer in. This isnt right just an example

=IF(a1-a2 is greater than 10 then put that answer in the cell if not just leave it blank?

View 5 Replies View Related

Add Dropdown That Pops Up Only When Certain Answer Is Given?

Nov 20, 2013

I would like to add a drop down that pops up only when a certain answer is given in a previous cell. For instance, if the user picks "Single Door" in cell E2, then in cell E6, I would like a box to pop up that says "HL/HR?" so that in cell E7, they have a drop down & can select either HL or HR. But, if they pick anything other than "Single Door" in cell E2, I don't want a box to pop up in cell E6 to prompt them to do anything else.

View 2 Replies View Related

Vlookup Or ? (Get Answer In B Column)

Oct 4, 2009

I have data in A column.

I want to Get anser in B Column.

Sheet1  ABC1S.NoCountryCode2E8481234567CroatiaE8483E8351234568SloveniaE835472123456900Ireland725JM123457000LuxembourgJM Excel tables to the web >> Excel Jeanie HTML 4

Answer Based on C Column....

View 9 Replies View Related

Determine MsgBox Answer

Dec 15, 2006

The macro I am working on will ask the user if they wish to transfer data to one of two Forms, held in two separate worksheets. The worksheet names are Record Form Games 3583 & Record Form PE 3581. The msgbox will ask "Is the data being transferred to Record Form 3583?" If Yes the sheet "Record Form Games 3583" will be set as the sheet as the one to transfer data to. If no "Record Form PE 3581" will be the destination sheet. This is what I have so far:

Sub Do_Admin()
Dim Record_Form As Worksheet
Msg = "Is the data being transferred to Record Form 3583?"
ans = MsgBox(Msg, vbYesNo)
If ans = vbYes Then Set Record_Form =
Sheets(Sheet"Record Form Games 3583")
End Sub

View 2 Replies View Related

Automatically Answer YES To Alert

Jan 6, 2007

My macro cuts and pastes a section of one sheet over the top of each remaining sheet in the workbook. It pauses before each paste and presents a message box (relating to copying over a named range) requiring the user to manually click on "Yes" in response to the question before continuing on. How can I modify my macro so that it finishes without requiring the user to click on "yes" for each sheet. In other words, how do I get the macro to automatically answer "Yes" to the message box ??

View 2 Replies View Related

IF Formula Returning Wrong Answer

May 1, 2014

I am trying to determine if I can write a formula that will read text in one cell, such as insurance and if true enter the amount from another cell and if false then 0. I have tried a IF statement by add the text to name manager. However, the answer is 0 rather than the amount in the selected cell. I might need to use a different formula or function.

View 10 Replies View Related

Changing Sum Of Two Cells To Equal -4 If Answer Is Zero

Dec 8, 2013

I wish to be able to add adjacent cells as follows, assuming I have a number in a1. (in B1) =a1-4.

If the answer is zero I would like to change it to -4 and then continue the process for more cells to read 16 ; 12 ; 8 ; 4 ; -4 ; -8 ; -16 etc.

View 6 Replies View Related

Sum And Divide Three Different Sets Of Numbers To Get One Answer

Dec 16, 2013

I have three different sets of numbers on a r12m that I have to add and divide by different numbers and not quite sure I have the formula right as when I do it manually on a calculator it comes out different.

The formula I have put together is

=sum(O4:z4)/10)+(sum(o5:z5)/200)+(sum(06:z6)/1000)

This is the three rows of data

221121
2333443201142
402448314034292331351663

Using the formula above the result is 0.81 but if I do it manually on a calculator it is 1.6 (by doing each line individually and adding results)

View 6 Replies View Related

Selecting Answer From Multiple Cell

Dec 27, 2013

So I am creating a board game in excel. I currently have a draw card feature to draw random cards. I also have section above where you can fill in the answer to the question and another 2 sections that flip to correct or incorrect. Those formulas work as =IF(AND(Sheet1!J6="When resubmitting the claim to another insurance should you be voiding an adjustment to the S code if one is posted?",Sheet1!I2="Yes"),"That is Correct!"," "). I have another for if Sheet1!i2="no" then it flips to that is incorrect. I want an OR formula that will be like if multiple cells have any text in them it will display them but only one cell at a time. So essentially a way for multiple questions to be able to be drawn and you can answer those questions and be told if they are correct or not.

View 14 Replies View Related

Return Answer Based On Cell Value

Aug 29, 2009

im looking to return an answer in cell c28. in b28 it will say "best goalkeeper"
in c28 i need a formula to look in range d2:d6 then return the highest answer and correspond that to whats in b2: b6. so we could say

(b2)shilton(d2) 33
(b3)corrigan (d3) 55
(b4)parkes (d4) 66
(b5)schmeichel (d5) 100
(b6)cudicini (d6) 14

in c28 it will return the answer schmeichel because he is the highest
and in d28 it would return the points he has.

View 2 Replies View Related

Compare Four Columns, Give Yes Or & No Answer

Sep 17, 2009

I have the attached worksheet with clients' names in four columns (A-D). The first names and last names must remain separate. I need one additional column that shows whether a full name (first and last) in C and D also appears in A and B.

Then one more column that shows how many times the name in C and D shows up, but only if it is also in A and B.

View 8 Replies View Related

How Can I Skip Or Automatically Answer Of Message?

Nov 23, 2009

I have a workbook that contains a macro that when executed creates a copy (duplicate) of one its sheets and places it in itself (the same workbook). The macro then prints the newly created sheet. After printing, the macro then erases the newly created sheet so that it is no longer a part of the workbook. My problem is that I get the Excel message "Data may exist in the sheet(s) selected for deletion. To permanently delete the data, press Delete". I would like add to my macro so that 1) the message is skipped or 2) the macro answers the message box (with Delete) so that no user input is required. I would like it if the user did not have to respond to this message.

View 2 Replies View Related

Parenthesis - Formula Give An Answer Of 178

Oct 27, 2005

The following formula shoud give an answer of 178. I think I am placing the
parenthesis in the wrong position.

The answer I get is 308669

=(((F22*71449)*0.4)+16147/C22)

Cell-F22 number is 1826
71449 is a constant number
0.4 is a constant number
16147 is a constant number
Cell-C22 is 10.8

View 10 Replies View Related

Can IF Function Result In Its Answer In A Different Cell?

Jan 15, 2010

Can this Formula work? Where if c2<e5 then its value is a number. The formula below is what i tried but it didnt work

=IF((C2<E5);"c5=value=f5")

View 2 Replies View Related

Formula Correct But Not Showing Answer

Mar 11, 2013

I am using this formula for long now

=SUMPRODUCT(('[Diesel Statement.xlsx]Nov 12'!$C$2:$C$251=$H$1)*'[Diesel Statement.xlsx]Nov 12'!$G$2:$G$251)

every month i just add a new sheet and change the month name in the formula to that eg

I changed it to

=SUMPRODUCT(('[Diesel Statement.xlsx]Dec 12'!$C$2:$C$251=$H$1)*'[Diesel Statement.xlsx]Dec 12'!$G$2:$G$251)

but now it is not calculating the answer is coming as #value!.

Then I tried to add up by

=VLOOKUP($H$1,'[Diesel Statement.xlsx]Dec 12'!$C$2:$G$215,5,TRUE)

but it does not add all the entries only one entry is shown.

I want the total of the column G. looking up for values in C = H1 value

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved