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 dencom 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 supportservice

  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.

Part and Inventory Search

Back
Top