Tag Archive: VBA

Jul
26
2013

How to Convert Select Excel Cells into Comma Separated Values (CSV) with VBA

Here is a simple yet powerful technique to convert selected cell values (rows or columns or mix of cells) into comma separated values (CSV) or delimited text format with the help of VBA. This will be useful when you want to merge cell values together quickly (from a key board shortcut for example) and use …

Continue reading »

Jan
15
2012

How to assign a keyboard shortcut for an Excel VBA Macro

Excel macros are excellent time savers. It is a good idea to assign some keyboard shortcuts to trigger them quickly to make the most of them. Assigning a keyboard shortcut when recording a macro If you record a macro, you will notice an option to assign the keyboard shortcut directly while naming your macro.   …

Continue reading »

Jan
08
2012

Reading Outlook Recipient Details (JobTitle, Alias, Address etc) Through VBA

Here is a piece of outlook VBA code which can be used to read recipient details such as JobTitle, Alias, Address etc. While there are many complex work around exist for this I believe the code below will simplify the details capture with the help of outlook ‘exchange user’ property.       Sub ReadRecpDetail() …

Continue reading »

Jan
08
2012

Adding Outlook Recipients through VBA

The following code will add e-mail recipients (To/Receivers list) through outlook VBA code           Sub Add_Receipients()   Dim myOlApp As Outlook.Application Dim myItem As Outlook.MailItem    Set myOlApp = CreateObject(“Outlook.Application”) Set myItem = myOlApp.CreateItem(olMailItem)    ‘adding recipients R1 = myItem.Recipients.Add(“email_ID1@somedomain.com”) R2 = myItem.Recipients.Add(“email_ID1@somedomain.com”)    ‘display the e-mail message with added recipients …

Continue reading »