Email attachment to GroupWise email sent with BCC

Posted on 2007-10-08
Last Modified: 2012-08-13
I've used the following successfully to send an email (that includes bc recipients) via GroupWise.

I 'stuff' the email addresses into strEmails and then the email is address accordingly.

Application.FollowHyperlink "mailto:" & strEmails

Problem: I now would like to include an attachment with this email. I found many other ways to do so using Outlook object, etc. However, I've tried those methods before arriving at the Application.FollowHyperlink one as I am using GroupWise and need BCC function.

Any suggestions?
Question by:scbdpm
    1 Comment
    LVL 65

    Accepted Solution

    bit of automation is required here. Example is for excel but can easily be adapted to use Access. You will need the activex controls and add them as references into your project

    if you want sample code, look here


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    In the previous article, Using a Critera Form to Filter Records (, the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
    In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now