Results 1 to 3 of 3

Send from Shared Mailbox using VBA code on Excel 2016

Threaded View

  1. #1
    Registered User
    Join Date
    08-05-2019
    Location
    England
    MS-Off Ver
    Office 2016
    Posts
    19

    Send from Shared Mailbox using VBA code on Excel 2016

    Hi All,

    I am looking for help on how to update my code attached to be able to send from our sharedmailbox

    Sub RectangleRoundedCorners1_Click()

    RowToProcess = 2
    Do While Range("A" & RowToProcess) <> ""
    esubject = "Case ID: 000"
    ebody = Sheets("sheet1").Range("N1") & " " & Sheets("sheet1").Range("E" & RowToProcess) & vbNewLine & vbNewLine & "We have recently been notified that " & Sheets("sheet1").Range("A" & RowToProcess) & "'s " & Sheets("sheet1").Range("C" & RowToProcess) & " AAA " & Sheets("sheet1").Range("F" & RowToProcess) & vbNewLine & vbNewLine & "AAA " & Sheets("sheet1").Range("A" & RowToProcess) & " AAA. " & vbNewLine & vbNewLine & "AAAAA. " & _
    "MESSAGE." & vbNewLine & vbNewLine & "Kind Regards" & vbNewLine & "Dixie Dean" & vbNewLine & "JOB ROLE"
    Set app = CreateObject("Outlook.Application")
    Set itm = app.CreateItem(0)
    With itm
    .Subject = esubject & Sheets("sheet1").Range("B" & RowToProcess)
    .To = Sheets("sheet1").Range("D" & RowToProcess)
    .CC = "NAME@NAME.co.uk"
    .Body = ebody
    .Display
    End With
    Set app = Nothing
    Set itm = Nothing
    RowToProcess = RowToProcess + 1
    LoopEnd Sub

    Any help would be greatly appreciated

    John
    Last edited by JohnPorter85; 09-30-2019 at 06:31 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Send Meeting Request from Shared Mailbox
    By orhanceliloglu in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-06-2020, 08:59 AM
  2. [SOLVED] Issue send email with excel 2016 true outlook 2016
    By kirana2014 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-12-2017, 11:34 AM
  3. Save mails sent from shared mailbox in that shared mailbox's Sent folder
    By LordClick in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-22-2016, 03:30 PM
  4. Outlook 2010 VBA Code to open a link from an unread mail in a Shared Mailbox
    By MHamid in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 10-31-2015, 03:46 PM
  5. Excel Macro using VB Script to send emails from Common/Shared Mailbox
    By k.vijayendran in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-11-2014, 01:48 PM
  6. [SOLVED] Show newl message envelop notification for all mailbox/shared mailbox added in outlook
    By Goku in forum Outlook Formatting & Functions
    Replies: 1
    Last Post: 07-04-2014, 01:23 PM
  7. Lotus emailing through excel in Shared Group Mailbox
    By davegugg in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-08-2010, 03:50 PM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1