+ Reply to Thread
Results 1 to 4 of 4

Macro to Change FROM Address in MS Outlook

  1. 07-10-2014, 11:33 AM #1
    harish.chinni
    harish.chinni is offline
    Registered User
    Join Date
    10-29-2013
    Location
    Bangalore
    MS-Off Ver
    Excel 2010
    Posts
    17

    Macro to Change FROM Address in MS Outlook

    Dear Experts,

    I am using the following code to send bulk mails from my MS Outlook to multiple users. Few years ago, I found this code thru Google.

    Now I have 02 Email IDs... this code helps me to send mail from Old ID (which is default in MS Outlook)... Now I need to send mails to multiple users with my New Email ID / 2nd Email ID (which is not a Default ID and it cannot be a Default ID for technical reasons).

    Please help me in sending mails with my New Email ID. Attached file is for your reference.
    or
    Let me know, if there is any other way to send mail with my 2nd Email ID.

    Regards,
    Harish S
    +91 99808 07270
    Attached Files Attached Files
    Last edited by harish.chinni; 07-10-2014 at 01:01 PM. Reason: Change in Subject Line
    Reply With QuoteRegister To Reply
  2. 07-11-2014, 02:09 AM #2
    morevijay1982
    morevijay1982 is offline
    Forum Contributor
    Join Date
    07-10-2012
    Location
    Bangladesh
    MS-Off Ver
    Excel 2007
    Posts
    129

    Re: Macro to Change FROM Address in MS Outlook

    sir you are aware of excel function concatenate and vlookup

    do some RnD work like this

    Dim asolApp As New Outlook.Application
    Dim asatts As Outlook.Attachments
    Set asmyItem = Outlook.CreateItem(olMailItem)
    Set asmyAttachments = asmyItem.Attachments
    asmyAttachments.Add "D:\FOR IT\Dec 13\Network Master\For Mail\xxxxx.xlsx"
    asmyItem.To = "[email protected]"
    asmyItem.cc = " "
    asmyItem.Subject = "xxxx Network Masterxxxx"
    asmyitem.htmlbody= "<HTML><font size=2 color= purple face=Calibri><span style='font-size:11.0pt;font-family:Calibri;color:#7030A0'>Dear Sir/Madam, <o:p></o:p></p>Please find herewith Hierarchy list<o:p></p> update Resignation / new appointment of teammate for the <o:p><U>Month Dec 2013<o:p> <span></u></b></p><o:p>Also inform for structure change to marketing service executive of said Division and Describe From which month the change is to be done<o:p></p>Treat this as urgent important your reply is must although there is no correction .<o:p></p><o:p>revert with latest by <U>28 Dec 2013<o:p><span></u></b></p><u><bold>N.B<o:p><o:p> <o:p><span></u></b> : <span></u></b>If you fail to provide correct information ,attached information is used for incentive calculation and sales report&nbsp;<o:p><o:p></P>Regards,&nbsp;<o:p></p>xxxxx"
    asmyItem.Send
    Reply With QuoteRegister To Reply
  3. 07-11-2014, 02:14 AM #3
    morevijay1982
    morevijay1982 is offline
    Forum Contributor
    Join Date
    07-10-2012
    Location
    Bangladesh
    MS-Off Ver
    Excel 2007
    Posts
    129

    Re: Macro to Change FROM Address in MS Outlook

    sir you are aware of excel function concatenate and vlookup

    do some RnD work like this

    i attached file 4 u

    regards
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 07-11-2014, 02:21 AM #4
    HaHoBe
    HaHoBe is offline
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,198

    Re: Macro to Change FROM Address in MS Outlook

    Hi, morevijay1982,

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. An application is trying to send email on your behalf
    By shaukat in forum Outlook Programming / VBA / Macros
    Replies: 4
    Last Post: 03-04-2012, 02:28 PM
  2. Auto Mailer using Macro
    By VENKYS in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-12-2010, 09:34 PM
  3. Send e-mail on behalf of a 3rd account VBA
    By dianao in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-17-2010, 04:42 AM
  4. Send email on behalf in Lotus Notes
    By janworld in forum Access Programming / VBA / Macros
    Replies: 0
    Last Post: 06-09-2009, 04:49 PM
  5. Email from Excel; MS warning "program is trying to send mail on your behalf"
    By KR in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-11-2005, 12:05 PM

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1