Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Feb 2003
    Location
    Melbourne, Victoria, Australia
    Posts
    139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Creating attachments for Outlook (Access 2002 SR-1)

    I wasn't sure where to place this post.
    I have an Access db which I use as the data source in a mail merge Word document to
    create a multipage document containing personal information as well as a .bmp signature.
    The Access db contains an 'e-mail' field, which is included in the above document.
    I would like to automate e-mailing the receipts information as an attachment.
    I don't need to create a mailmerged Word document if it is easier/cleaner to do it directly from Access.
    Any advice gratefully accepted.
    Michael

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Creating attachments for Outlook (Access 2002 SR-1)

    There are several options for doing this, but in my view the simplest (i.e. it doesn't involve any code or automation) is to make your Word mail merge a merge to email rather than to a document. That is one of the options you get with a mail merge document. Help in Word will give you some step-by-step guidance if you use the Answer Wizard and put in merged email and pick the second topic displayed.
    Wendell

  3. #3
    2 Star Lounger
    Join Date
    Feb 2003
    Location
    Melbourne, Victoria, Australia
    Posts
    139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Creating attachments for Outlook (Access 2002 SR-1)

    Thanks Wendell,
    I didn't even consider looking for an 'easy' solution.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •