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 dencom 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: *

  • Users: supportservice
  • Content: Threads
  • Order by date
  1. supportservice

    Emailing Directory/Catalog Mail Merge

    I am trying to use macropod's guide and got the macro in my email merge document. It created the EmailDataSource.doc However it looks like this and did not email? Files Not sure what I am doing wrong. Could you help me? Dear Accounts Receivables Department of BERRY NETWORK, Please charge...
  2. supportservice

    Mail Merge List by Name

    I found an article and I can't seem to make it work. This is the part that I would like to use: [link]http://support.microsoft.com/kb/211303/en-us[/url] I've replaced it with my field names here: { If { MERGESEQ } = "1" "{ MERGEFIELD «VendorName»}" ""} { SET Place1 { MERGEFIELD...
  3. supportservice

    Assistance with emailing list of open invoices to each Vendor in Message

    Hello, I haven't come across posts that could help me on this issue. I have a table with open invoices for vendors. Each vendor needs to be emailed the list of invoices with the total to charge in the body of the email message. Subject: "Please charge credit card on file the following...
  4. supportservice

    Send emails of report that lists all open invoices by Vendor

    I've searched and searched and can't seem to really find what I'm looking for. If there is a code out there to achieve the following please direct me! I apologize for the lack of finding it otherwise :-( I have a database. There is a macro that extracts data out that creates a table...
  5. supportservice

    How return a year ago from date?

    What is the best way to replace the 366 days ago, as some months it might be 367, etc ... (31 days vs 30 Days, and Feb. with 28 or 29 days) to return a year ago from the date selected on the FromDate? (IIf([PostingDate] Between Forms!DateSelector!FromDate-366 And...
  6. supportservice

    Calulating of groups / categories?

    I'm having a road block on how to go about calculating Net Income and Operating Income with the set of data CategoryGroupID CategoryGroupDesc CategoryGroupCode SumOfMTD SumOfLMTD SumOfYTD SumOfLYTD 1 Revenue R $740,079.83 $750,968.68 $2,972,403.40 $3,001,001.56 2 Cost of Sales C ($247,339.60)...
  7. supportservice

    Combining Results in a Union Query?

    Hello, I have this UNION query but need to have the totals summed when the MainAccountDesc is the same. SELECT RotocoSummary.AccountCategoryDesc, RotocoSummary.MainAccountDesc, RotocoSummary.MTD, RotocoSummary.LMTD, RotocoSummary.YTD, RotocoSummary.LYTD FROM RotocoSummary LEFT JOIN SB1Summary...
  8. supportservice

    GM 6.7 E-mail center folder tree is gone

    Anyone know how to get the E-mail center folder tree back? it disappeared. F5 (short-cut) does not
  9. supportservice

    Dynamic Monthly Crosstab report wih actual monthly names?

    Greetings I found this great article: http://tek-tips.com/faqs.cfm?fid=5466 And wanted to see if someone could expand on that? I would like to set the date range to always show one month prior + 5 equaling 6 months with the relative dates but to show the actual month names with the year in...

Part and Inventory Search

Back
Top