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 Mike Lewis 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
  • Order by date
  1. supportservice

    Emailing Directory/Catalog Mail Merge

    ok thank you!
  2. supportservice

    Emailing Directory/Catalog Mail Merge

    Yes that is fine that it doesn't state save that document. However I ran the RunMerge macro in that very 2nd document as stated. I had someone else review it as well. same thing. all the messages I posted comes up. So we BOTH do not know why this is happening. Thank you. It would be great if...
  3. supportservice

    Emailing Directory/Catalog Mail Merge

    Would you by chance know the VBA for Access? To email the detailed list to the Vendors in the body of the message? If that's easier that would probably be better then using this Word method?
  4. supportservice

    Emailing Directory/Catalog Mail Merge

    I have the code you have in the tutorial and only that as specified in the tutorial. What I am saying is it doesn't say to save it as anything but to simply then run the RunMerge macro from the 2nd document with the only code you have in your document. {QUOTE{IF{MERGESEQ}= 1 {SET Key...
  5. supportservice

    Emailing Directory/Catalog Mail Merge

    The document it creates "EmailDataSource.doc" would be the 3rd? Yes, the 1st document is my "EmailMerge-Template.doc" with all the info and VBA. the 2nd is just the code as it states in your tutorial, though it doesn't say save it? And in here add the 'RunMerge' macro. Which I did and got all...
  6. supportservice

    Emailing Directory/Catalog Mail Merge

    Two of us are going through each step and the confusion, as stated above remains. I am quoting the parts where I seem to be stuck / falling short? {QUOTE{IF{MERGESEQ}= 1 {SET Key ""}}"{IF{MERGEFIELD VendorName}<> {Key} "{SET Key {MERGEFIELD VendorName}} |{MERGEFIELD EmailAddress} |...
  7. supportservice

    Emailing Directory/Catalog Mail Merge

    It did not do what your example shows: The ‘RunMerge’ macro saves a document named ‘EmailDataSource.doc’ in the same folder as your ‘Email Merge Main Document’, containing the e mail mailmerge data in a table like: Recipient Data ACTmanager@nowhere.com City Representative Sales Canberra Yang...
  8. supportservice

    Emailing Directory/Catalog Mail Merge

    According to page 22, it says
  9. supportservice

    Emailing Directory/Catalog Mail Merge

    Thank you I used the page 22 macro and made edits to fit. It crashes when generating the EmailDataSource.doc Though I can then open it to see the results. But the 1st record is missing the date. The last record is missing the total for the last Vendor. Then how does it email? I'll review the...
  10. supportservice

    Emailing Directory/Catalog Mail Merge

    Oops, here's the link: http://www.4shared.com/zip/JC87TvG_/EmailMerge-Template.html http://www.4shared.com/zip/JC87TvG_/EmailMerge-Template.html
  11. 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...
  12. supportservice

    Mail Merge List by Name

    Never mind! I finally got it working now! Thank you so very much! I am extremely grateful for your patience with me and helping me with this!
  13. supportservice

    Mail Merge List by Name

    Oops: Updated Doc
  14. supportservice

    Mail Merge List by Name

    Thank you! I appreciate your help! I've attached what I was able to do. It's working very strangely though? http://www.4shared.com/office/JYRHMxZD/mailmerge_document.html
  15. supportservice

    Mail Merge List by Name

    Yes and as mentioned I inserted the code that is supposed to list the invoices per Vendor but it is not. Even after making sure Directory is selected. This why I do not get what I am doing wrong.
  16. supportservice

    Mail Merge List by Name

    I'm sorry. Not sure what that'll do with the problem? I know how to select the field then right-click to toggle field codes
  17. supportservice

    Mail Merge List by Name

    Yes and I thought perhaps with the code and your tutorial will help. You say all the code is in your tutorial ... apparently I am not seeing it?? NSW Coffs Harbour Roulston $4,000 Dubbo Kristiansen $6,700 Newcastle Avard $3,400 Newcastle James $8,600 Sydney Brown $5,300 Sydney Driver $8,700...
  18. supportservice

    Mail Merge List by Name

    Because, sadly, I am not getting. So I am trying to incorporate what seems to be more helpful re: Code, add your explaining ... but I am coming up quite short. I realize how much I do not know Word. Have just used in it's simplest form of word processing only. This is quite complex, at least...
  19. supportservice

    Mail Merge List by Name

    Sorry. But that is all ready done. I am stuck at this point then Force Each New Category To a New Page A minor change to the field coding from the previous examples inserts a page break whenever the key field changes. The following field codings show how you might go about this: • with the...
  20. supportservice

    Mail Merge List by Name

    Ok all steps 2-8 are done and easy enough. 1. Sorted on 'Key' which is VendorName. This is done 2. I can't find Query Options?

Part and Inventory Search

Back
Top