Results 1 to 4 of 4

Thread: Change excel vba code to work with Groupwise

  1. #1

    Change excel vba code to work with Groupwise



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi programmers

    I have an excel workbook which is coded to work with MS Outlook. Basically the programme converts a selected sheet or sheets to pdf and attaches them to an e-mail and from selected cells the To, subject and body text are automatically filled in. This works well with Outlook but I need to convert it to work with Groupwise version 7.02.

    If anyone can help it would be greatly appreciated. Here's the Outlook version of the vba (it is rather long, found it on another site) attached.
    Attached Files Attached Files

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,250
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Hi golfman, and welcome to the site.

    My first suggestion would be to split this routine into two separate pieces. The first would be to create the PDF's and save them, the second would be to send the email from GroupWise. This will make it easier to develop, troubleshoot and maintain, and give you the bonus that you can use the pieces individually.

    I have an article on my site about sending email from Groupwise that you can find here. I'll take a look at splitting out the PDF portion for you a bit later after I catch up on some other posts.
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training) or with my book M is for Data Monkey!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  3. #3
    Thanks Ken

    I'll have a look at your article.

    Vyrn

  4. #4
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,250
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Hi Vyrn,

    Just following up to see if that was any help. If not, I'm happy to help break things down, I've just been really busy the last couple of days.
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training) or with my book M is for Data Monkey!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

Posting Permissions

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