Search results

I have been trying for hours to send form output via E-mail. I have got it working, but the body only outputs 1 line. Please see code below and the resulting e-mail is as below The e-mail only outputs the last line in Body from the script, please can anyone help?

Hi I am wanting to preempt data in list boxes listbox1 Fruit Vegetable listbox2 (If Fruit Is Selected) Apple Banana Orange listbox2 (If Vegetable Is Selected) Potato Peas Carrot If Fruit is selected in Listbox1 - Then Listbox2 should have the options Apple Banana Orange If Vegetable is...

I am trying to configure remote assistance, (on click). Whereby I have the PC Name for the remove assist. eg: PCNAME is Laptop1 I have managed to do this with remote desktop Private Sub PC_Name_Click() Shell ("mstsc.exe /v:" & PC_Name) End Sub (PC_Name is the field that holds the value) Can...

I can import the global address book but not the actual SMTP address, please can someone advise how do to this (the SMTP is on the exchange sever, but when I import, everything imports apart from the SMTP. Please can someone advise?:banghead:

I am trying to do a find and replace in msword problem: I need to search for the following format REF NO: 84542654 REF NO: 21364589 i need to replace the first 4 digits in the number with * so the iuput should be REF NO: ****2654 REF NO: ****4589 I cannot seem to get this working I have...

I am trying to do a Double nested vlookup where vlookup 1 looks for DOB in range and and vllokup 2 looks for surname in range, only when both vlookups match will it return the corresponding column value =IF(VLOOKUP(Sheet1!A1,Sheet3!$A:$G,(VLOOKUP(Sheet1!F1,Sheet3!$F:$F,1,FALSE)),FALSE),"NULL")...

Hi I have a documemt that has been run through a macro that i created and eventually i get the records to split as i want them. However when each record ends it inserts a blank page I have done most of the adjustments with find and replace, however you cannot do find and replace when...

I am trying to use a Vlookup, in a Spreadsheet that has 15000 records. Column A has account numbers (which are repeated a few times) and Column B has person names. What I am trying to do is Vlookup repeat account numbers and show the person linked to that account in the form of a row. Vlookup...

I need help I have a 5000 page document and I need to run a macro so that it searches for a value (eg - "32 entries per line") and if that value is found then THAT page that the entry is found is deleted and so on until the end of the document. Can someone help me with the macro/vb code...

How can i set the iamge to TIGHT formatting - When recording the macro this option is greyed out any VBA coding to force this formatting? CODE USED If ActiveWindow.View.SplitSpecial <> wdPaneNone Then ActiveWindow.Panes(2).Close End If If ActiveWindow.ActivePane.View.Type =...

Is it possible to setup excel (VBA) to return a msgbox if certain text is entered into a cell - and if not then no msg is displayed? ie if cell value is "test" then msg box appears with msg if cell value is anything else then msg box does not appear If possible can this be done on a...

Please can someone help I am trying to add code where by when i click the exit button, i want the function to check all fields in record to see if there is a value present if no value then msgbox needs to be displayed to show which field is missing data eg If User_ID = "" Then MsgBox "Please...

Please can someone help I am using switchboards, and i open the form in edit mode. Is there anyway to show the present Date in the text box. The task is to save the Date in the field (so that it shows in the relevant table) In other words once Todays date is showing in the form then when i...

Hi all Just waning to know, if i have a set number of values and i want to know how many times they have appeared, how would i display this :eek: eg 3 3 5 23 5 6 I am wanting to know if how many times 3 has appeared, Answer is twice or 2 How would I go about doing this in the spreadsheet...