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 derfloh 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 Hazmataz

  1. Hazmataz

    SendObject Macro without attachments??

    Hi Can anyone help me with this topic? I am sure that what grnzbra put is correct but I don't really know how to implement it. Like I said I am quite new to this Access business! Thanks H
  2. Hazmataz

    SendObject Macro without attachments??

    Hi Thanks again but like I said I am a bit new to this: Dim db as database Dim rs as recordset Dim str as string set db as currentdb set rs as openrecordset("QueryName") rs.movefirst while not rs.eof str = str & rs.Company & Chr(9) & rs.Price & Chr(9) & rs.OrderNo & chr(10) &...
  3. Hazmataz

    SendObject Macro without attachments??

    Hi, The query uses todays date and then gets the Total Price, Company and Order Number for all orders placed that day. It needs to arrive something like: Company Price Order No. Tek-tips 9.99 o1652485 Microsoft 18.50 o1652499 So yeah, it needs...
  4. Hazmataz

    SendObject Macro without attachments??

    Hi Thanks for replying and sorry for being ignorant but the information comes from a query so how do I gather that information into a string? (I assume that string then goes in the 'message text' field in the macro?) Thanks again Haz
  5. Hazmataz

    SendObject Macro without attachments??

    Hi, I am a newbie to Access and trying to improve the database at work. I am using SendObject to send the data I require BUT the computers are a bit slow (as are the ladies in accounts) and they don't want to use attachments. So can I send the information I want in THE BODY of the EMail (we...
See more

Part and Inventory Search

Back
Top