Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. diehippy

    Create user Mailbox script no working

    Hi Thanks for replying, I need to give you some more details, this script runs from the following batch file that is scheduled to run overnight on a microsoft windows server 2008 r2 with exchange 2007 batch file reads "c:\windows\system32\windowspowershell\v1.0\powershell.exe" -psconsolefile...
  2. diehippy

    Create user Mailbox script no working

    Hi All, Thanks in advance for any help given, I have recently taken over a new job role from a collegue who has a powershell script that create mailboxes from a csv file and for some unknown reason has stopped working, I am new to windows powershell and I was wondering if anyone had any ideas...
  3. diehippy

    excel email attachment is blank

    Hi, Here is the new code Option Compare Database Private Sub Command4_Click() On Error Resume Next Dim objOutlook As Object Dim objEmail As Object Dim MyDb As DAO.Database Dim rsEmail As DAO.Recordset 'Dim PER As DAO.Recordset Dim sMessageBody, strCC Dim apetext As Variant Dim abdtext As...
  4. diehippy

    excel email attachment is blank

    Hi, Sorry for being vague, I put the code in like this: If PER.BOF = True And PER.EOF = True Then MsgBox "No data in recordset" Else objSheet.range("A9").copyfromrecordset PER objworkbook.saveas Application.CurrentProject.Path &...
  5. diehippy

    excel email attachment is blank

    I did put the code in, sorry still get the same answer.
  6. diehippy

    excel email attachment is blank

    Many Thanks for the advice PHV and VBAJOCK, but I still have the same problem with there being no sheets in the workbook, its like it has somehow closed the workbook before doing the save as. I have looked everywhere and this code is correct, any help will be much appreciated Many Thanks Diehippy
  7. diehippy

    excel email attachment is blank

    Many Thanks vbajock for you fast reply, I check and this was an error when I transferred over to notepad not an error in the code, but thanks for pointing that out I thought I had missed something but I could not see what. the file attaches correctly and looks like an excel file even has kb...
  8. diehippy

    excel email attachment is blank

    Hi All, I have been working on an email project where I use a couple of sql queries in access to send an email with an excel attachement. It all works quite will except that the excel attachment comes up blank or closed? I am not sure anyway the worksheet is gone and I am unsure why, any help...
  9. diehippy

    Adding query data to an HTML template

    Thanks Lameid, I will try adding a loop to PER see what comes back Many Thanks Diehippy
  10. diehippy

    Adding query data to an HTML template

    Hi All, I have put together a vba script that runs two sql queries using the data to populate a html template and then call that template and email it to an email address from one of the queries, this does almost everything I want except that if the query PER has more than one line of data...
  11. diehippy

    Multiple emails with html body using two sql queries getting stuck

    Thanks for your Help GComyn, It is most appreciated, I have changed my code to the following which done almost what I wanted it to do Private Sub Command4_Click() On Error Resume Next Dim objOutlook As Object Dim objEmail As Object Dim MyDb As DAO.Database Dim rsEmail As DAO.Recordset Dim PER...
  12. diehippy

    Multiple emails with html body using two sql queries getting stuck

    Thanks Traingamer, been looking at the code for ages missed that simple point PER is populating my html body of my email through a function call ReturnTemplate. Being quite new to vba, I would like to link the two queries together rsEmail and PER, both queries have a field that can be linked...
  13. diehippy

    Multiple emails with html body using two sql queries getting stuck

    Hi, I was wondering if anyone would be so kind to have a look at my code and tell me where I am going wrong. My code has calls two queries the first populates the email add and the subject line and the other query fills the html template I have borrowed a template function to call it from an...
  14. diehippy

    exception error on cursor update package

    Hi Dagon, Many Thanks for your advice, I have now chaged my package accordingly and it all works fine now Many Thanks for your help again Diehippy
  15. diehippy

    exception error on cursor update package

    Hi All, I was wondering if someone could give me some advice on why my package keep failing on the exception that I have added to the end of two update statements. The error that I am getting is the following "PLS-00103: Encountered the symbol ""EXCEPTION"" when expecting one of the following...
  16. diehippy

    update that does not update with the correct value

    Thanks Dagon, I know that I am on the right track, just need to figure out the update Many Thanks Mark
  17. diehippy

    update that does not update with the correct value

    Hi Dagon, It is possible, I need to setup the second update with a seperate cursor to get the correct values in the second update. You thoughts will be most appreciated Many Thanks Mark
  18. diehippy

    update that does not update with the correct value

    Hi Dagon, Thanks for the reply, I have restricted the first update to only update where first grade = 'FL' or first_grade is null so any other data should come back as 'N' if it has not updated due to this restriction. As I understand it. Many Thanks Diehippy
  19. diehippy

    update that does not update with the correct value

    Hi All, I was wondering if you could help me I have created a pl sql script that when run, will update a table with some values then update the tables that the values came from with either a success or failure except it is just updating every record the same either success or failure and not a...
  20. diehippy

    email from excel using vba using the email address from an excel sheet

    Hi Skip, It works, that is brillant, I can not thank you enough for this, I thought I was going to lose my mind (hopefully not) can I use a simlar range code for creating the filename as I need to use the selected cells data from the third sheet Many Thanks again you have been a absolute star...

Part and Inventory Search

Back
Top