• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Macro to send email automatically through outlook


New Member
Hi Gurus,

I have written a VBA code to send mails automatically through outlook, data from excel. Its working fine in my system but not working from client's system (citrix operated remote system).

Is there any specific settings to be applied for remote outlook server.


Kenneth Hobson

Active Member
Did they add Citrix to Outlook?

How do I add Citrix to Outlook?
Click on your name in the upper right and then click on Account Settings.
  1. Then click on Tools on the left menu.
  2. Locate Citrix Files Outlook Plugin in the list of apps and click the Download button.
  3. Once the installation file downloads, locate the file and close Microsoft Outlook.

I am trying to create and send ent emails to recipients based on the values in an excel sheet. Can you please post a copy of the VBA script you are using? Would appreciate it. Thanks.