Using your hard work, I was able to modify your code. I took your line
Set CCRecipient = Mail.Recipients.Add(Mail.SenderEmailAddress)
And replaced it with
Set CCRecipient = Mail.Recipients.Add(Mail.SentOnBehalfOfName)
Bada-bing, bada-boom.
Hornblower409, my hat is off to you.
Please...
Hornblower409,
Again, I am delighted that you are taking on this challenge. We are very close. This ran, without an error, but....
We intended that if I send this from *@mydomain.com ON BEHALF OF test@mydomain.com, then test@mydomain.com is added as a CC to the message.
What happened is that...
I apologize for not understanding. Yes, that is the logic I would like to apply. I always use the same account to send this kind of message, and that account is *@mydomain.com.
When I use this process, the outgoing email shows:
Matt Metz <*@mydomain.com>; on behalf of; mydvac@mydomain.com"...
Thank you, Hornblower409. You suggested this code, but I don't know where it goes in the script above.
How about this?
If FromAddress <> AccountDefaultAddress then
Add FromAddress to CC
End If
Can you reply with the entire VBA private sub code, please?
Thank you!
-Matt
Hornblower409, my apologies. I missed this last post from you (Jan 7). I appreciate your efforts to help. Here are my responses:
Correct: I am NOT using MS365/Exchange shared mailboxes. This is a simple IMAP account accessing my "wildcard" account on the Ionos server.
I am not familiar with...
This did not work. I've attached a screenshot of the error. I don't know enough about coding to figure out what needs to change in the code to address this error.
I often use the "send on behalf of" feature in Outlook 365. But I wish the email to always cc the account on which I'm sending on behalf.
Here is what I do today:
> click to send a new email from my account: e.g. me@mydomain.com
> Click on the FROM button and in the drop-down, click on OTHER...
This relates to Outlook 365 desktop version.
Diane showed me how to write VBA macros to search my email for certain criteria, such as all unread items across multiple accounts, etc.
Now I would like to use a VBA macro (which I will invoke with a custom button on a customized ribbon) that will...
Thanks to Diane for showing me how to create a unified inbox using VBA. I now have a custom icon on my ribbon that produces a "unified inbox" view - that is, a listing of all items in all the inboxes of my many email accounts I have in Outlook 365.
My next question is this: Is there a way to...
Diane, YOU DID IT AGAIN!
When I set up my new W11 computers, I was careful to set my default email account, but failed to point the default DATA FILE to the one containing my calendar. I have confirmed now that my old W10 machine was properly pointing to the proper data file, and on my W11...
I appreciate your help. I followed your instructions. I opened the VBA Editor, clicked in the STARTUP section, then selected RUN > RUN SUB. I then switched over the Calendar, created a new CM TEST item, and it was NOT converted to FREE/NO ALERT - it was BUSY and (my) default 45 minute alert.
-Matt
Diane, this portion of the VBA script is not working at all. New appts created on my Windows11 machine with CM in the subject have my default "time: busy" and "reminder before: 45" that are my default values. I am using exactly the script above between and . Typically I am in CALENDAR view, not...
Diane, the VBA code you helped me set up in Outlook to conditionally turn off reminder and show time as free for any appointment with "CM" in the subject was working just fine on my Windows 10 machine. The same code, replicated to my Windows 11 machine, does not work. Do you know why this is...
Diane, this macro is not working at all now. It is NOT setting the time as free, and is NOT turning off the reminder. The same macro is working properly still on my W10 machine, but not in W11.
Diane,
After setting up my new computer (now Windows 11 Pro) and installing Microsoft 365, this macro is only doing one-half of what it was doing on the old computer. For new appointments with CM in the subject, it IS setting the time as free, but it is NOT turning off the reminder. It's...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.