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!

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

Recent content by SPYatwork

  1. SPYatwork

    Excel data to Word Email Merge

    Guy's my code now fails at: ActiveDocument.Mailmerge.OpenDataSource Name:= _ "C:\Users\SP\desktop\Merge File.xlsx", _ ConfirmConversions:=False, ReadOnly:=False, LinkToSource:=True, _ AddToRecentFiles:=False, PasswordDocument:="", PasswordTemplate:="", _ WritePasswordDocument:=""...
  2. SPYatwork

    Excel data to Word Email Merge

    Many thanks Skip!
  3. SPYatwork

    Excel data to Word Email Merge

    Sorry, this is the line it fails at: ActiveDocument.Mailmerge.MainDocumentType = wdEMail
  4. SPYatwork

    Excel data to Word Email Merge

    Guy's I'd really appreciate some help! I have Office 2010 and an Excel sheet that I have used as the source in a Word Email merge. I am trying to avoid the user having to open Word & run the Merge manually by providing some code in Excel to perform the task & create the emails. The code I have...
  5. SPYatwork

    Excel: Fill range of cells with "NA" if another cell ="xHigh"

    Thanks Skip, I need this to run on all rows checking q1,q2,q3 etc and filling in W1:BH1, W2:BH2, W3:BH3 etc and also to trigger automatically ( maybe worksheet on change event?). Thanks again
  6. SPYatwork

    Excel: Fill range of cells with "NA" if another cell ="xHigh"

    Thanks for all replies. The conditional format option works but is not viable as I need the text "NA" in the cells. The option of refering to data on another sheet is not really viable either as this is a constantly updating document. Pasting formulas into range W:BH would overwrite existing...
  7. SPYatwork

    Excel: Fill range of cells with "NA" if another cell ="xHigh"

    Yes I want to add string "NA" not an error value Yes, if q4 ="xHigh" all cells in that row between Cols W4:BH4 should have the value string "NA". Must apply to all rows in sheet i.e if q5 - "xHigh" then w5:bh5 should be "NA" I cant use a fomula because the cells in W:BH may have existing data...
  8. SPYatwork

    Excel: Fill range of cells with "NA" if another cell ="xHigh"

    I need a way to populate cells in W4:BH4 with "NA" if Q4 = "xhigh". (this needs to work on all row in sheet not just row4) Any help appreciated!
  9. SPYatwork

    Hide VBA window when code is called

    Ah found the problem - thanks Sub NIF_UI() DoCmd.RunCommand acCmdDebugWindow
  10. SPYatwork

    Hide VBA window when code is called

    I use a form's onclose event to call a function that in turn runs some code to send an email from Access. The problem is that when the code is run the VBA window becomes visible to the user and I would like to hide it. Any help appreciated!
See more

Part and Inventory Search

Back
Top