locked
to Generate an email to send the current document from Word (2003) using VBA RRS feed

  • Question

  • Windows 7, MSOffice 2003

    I am working with an original document in Word 2003 which may contain several references to as many as 50 people.
    The document is currently personalized for each recipient with a copy automatically printed for that person (using VBA), before restoring the document to its original state and moving on to the next person in the list.

    I may have email addresses for many, but not all, of the recipients and would wish to generate and send an email, attaching the personalized document, from within the VBA code, rather than printing out a hard copy, when I have a suitable address held in a 'look-up' table.

    I now have code to print the amended document, and also to save the personalized document including the recipient's name in the filename.

    It's generating the email that I'm having difficulty with . . .
    Any help would be most appreciated, thank you.


    Wednesday, January 5, 2011 2:44 AM

Answers