Can vba(for outlook) do these 2 things or not?

Status
Not open for further replies.
W

weidongli

Member
Outlook version
Outlook 365 64 bit
Email Account
Office 365 Exchange
Hello,

Here are 2 things I want to do, but I don't know whether VBA for outlook can do:

1. setup 50 email accounts in outlook365, account list is in a csv file.
2. save emails, contacts and calenders of these 50 email acconts to .pst files daily.

thanks!
 
1. You need to use Redemption and VBA to do it.
2. Are you adding the accounts as POP or IMAP? The mail will sync daily - you can backup up pst files easily, but IMAP needs exported or copied out using vba.
 
Diane Poremsky said:
1. You need to use Redemption and VBA to do it.
2. Are you adding the accounts as POP or IMAP? The mail will sync daily - you can backup up pst files easily, but IMAP needs exported or copied out using vba.
Click to expand...
Hi Diane,
Thank you for your help.
I searched the question "can vba setup email account in outlook?" serveral time on Microsoft ChatGPT yesterday.
ChatGPT gave me two different answer below:
1.Yes, VBA (Visual Basic for Applications) can be used to automate the process of setting up an email account in Outlook. Here is a sample code that you can use to create an Outlook email account programmatically using VBA:
2.I'm sorry, but VBA cannot set up an email account in Outlook. This task requires administrative privileges and cannot be done through VBA code. To set up an email account in Outlook, you need to manually configure the account settings by providing the email address, incoming and outgoing server information, username, and password. However, you can use VBA to automate the process of sending an email using an existing email account in Outlook. Here's an example of how to create and send an email in Outlook using VBA:

ChatGPT provide me 5 sample codes, 5 key code lines below:
Set olAccount = olNs.Accounts.Add(strEmail, "POP3")
Set olAccount = olNs.AddAccount(strEmail, "IMAP")
Set olAccount = olAccounts.Add(your@email.com, "EXCHANGE", "your password")
Set objAccount = objOL.Session.Accounts.Add("Email Address", "Display Name", "Incoming Mail Server", "Outgoing Mail Server", "Username", "Password")

but these 5 code line can not be run in VBE, the same error:"The object don't support this attribute or methord"

it makes me confused, these 5 code lines that Microsoft provide need third party Library?

Regards.
 
Status
Not open for further replies.
< Free Malwarebytes Download - 1510-370-1986 | Add keywords from Listbox to the message body where cursor is placed >
Similar threads
Thread starter Title Forum Replies Date
efire9207 VBA Outlook Contacts Outlook VBA and Custom Forms 6
B Requesting VBA code to make Outlook prompt for confirmation when deleting a task? Outlook VBA and Custom Forms 4
J Outlook VBA to send from Non-default Account & Data Files Outlook VBA and Custom Forms 4
P VBA to add email address to Outlook 365 rule Outlook VBA and Custom Forms 0
M Outlook 2016 outlook vba to look into shared mailbox Outlook VBA and Custom Forms 0
D Outlook VBA forward the selected email to the original sender’s email ID (including the email used in TO, CC Field) from the email chain Outlook VBA and Custom Forms 2
L Fetch, edit and forward an email with VBA outlook Outlook VBA and Custom Forms 2
BartH VBA no longer working in Outlook Outlook VBA and Custom Forms 1
richardwing Outlook 365 VBA to access "Other Actions" menu for incoming emails in outlook Outlook VBA and Custom Forms 0
J Outlook Rules VBA Run a Script - Multiple Rules Outlook VBA and Custom Forms 0
C Outlook (desktop app for Microsoft365) restarts every time I save my VBA? Using Outlook 1
E Outlook 365 Outlook/VBA Outlook VBA and Custom Forms 11
J VBA for outlook to compare and sync between calendar Outlook VBA and Custom Forms 1
E Outlook VBA change GetDefaultFolder dynamically Outlook VBA and Custom Forms 6
S vba outlook search string with special characters Outlook VBA and Custom Forms 1
U Outlook 2019 VBA run-time error 424 Outlook VBA and Custom Forms 2
G VBA to save selected Outlook msg with new name in selected network Windows folder Outlook VBA and Custom Forms 1
F Excel VBA to move mails for outlook 365 on secondary mail account Outlook VBA and Custom Forms 1
K Outlook Office 365 VBA download attachment Outlook VBA and Custom Forms 2
V vBA for searching a cell's contents in Outlook and retrieving the subject line Outlook VBA and Custom Forms 1
B vBA for exporting excel file from outlook 2016 Outlook VBA and Custom Forms 3
S Excel vba code to manage outlook web app Using Outlook 10
H Custom Outlook Contact Form VBA Outlook VBA and Custom Forms 1
S Problem Checking the available stores in my Inbox (Outlook VBA) Outlook VBA and Custom Forms 0
S Outlook VBA How to adapt this code for using in a different Mail Inbox Outlook VBA and Custom Forms 0
O VBA Outlook Message Attachment - Array Index Out of Bounds Outlook VBA and Custom Forms 0
J Want to learn VBA Macros for Outlook. What book can you recommend? Outlook VBA and Custom Forms 2
M Outlook 2013 reminder email by using Outlook vba Outlook VBA and Custom Forms 2
D Outlook VBA error extracting property data from GetRules collection Outlook VBA and Custom Forms 10
O Email not leaving Outbox when using Excel VBA to sync Outlook account Outlook VBA and Custom Forms 4
L Moving emails with similar subject and find the timings between the emails using outlook VBA macro Outlook VBA and Custom Forms 1
B Outlook Business Contact Manager with SQL to Excel, User Defined Fields in BCM don't sync in SQL. Can I use VBA code to copy 1 field to another? BCM (Business Contact Manager) 0
N How can I increase/faster outlook VBA Macro Speed ? Using Outlook 2
N Outlook Email Rule execution through shortcut keys (VBA codes) Using Outlook 1
A VBA Code in Outlook disappears after first use Outlook VBA and Custom Forms 1
dweller Outlook 2010 Rule Ignores VBA Script Outlook VBA and Custom Forms 2
G Outlook VBA and Google Calendar ("Events") Outlook VBA and Custom Forms 1
J VBA Outlook : Subject line : Cut and Paste name to heading , number to very end of the body of Email Outlook VBA and Custom Forms 1
B Advanced Search in MS Outlook by VBA and SQL Outlook VBA and Custom Forms 2
K Outlook Archive to PST Files by Date Range VBA Script? Outlook VBA and Custom Forms 1
J Help Please!!! Outlook 2016 - VBA Macro for replying with attachment in meeting invite Outlook VBA and Custom Forms 9
S Find a cell value in excel using outlook vba Using Outlook 1
J Execute Add-In Button from VBA Outlook 2016 Outlook VBA and Custom Forms 1
J Open an outlook email by Subject on MS Access linked table with VBA Outlook VBA and Custom Forms 10
D create an html table in outlook custom form 2010 using vba in MsAccess Outlook VBA and Custom Forms 7
M Slow VBA macro in Outlook Outlook VBA and Custom Forms 5
T Outlook AntiSpam with VBA Outlook VBA and Custom Forms 1
F "Move to" O365 feature to Outlook client via VBA Outlook VBA and Custom Forms 4
B query outlook using vba Outlook VBA and Custom Forms 13
J VBA to switch Outlook online/offline Outlook VBA and Custom Forms 4

Similar threads

Back
Top