Outlook Mailbox VBA script


A script that runs when an email is sent from a Project Mailbox which populates a sequential number in the Subject line (replacing ### symbols) by checking the Sent Items to find the next number to use.

Subject line example format: *RFI-### Enter description here


I will create an outlook template, such as an RFI or Notice to Engineer or whatever it may be. Example attached.

I will save the template to have three letters a dash and then three # symbols.

The script is to read the first character of the Subject line of the Sent items to look for a * symbol.

IF it finds this then it reads the following three alpha characters (which could be anything).

The three alpha characters are then checked against the Sent Items (or possibly a separate log if more efficient??) for a match.

The script then assigns the next sequential number and populates this number instead of the three # symbols in the Subject field. E.g. *RFI-005

Email gets sent.

Beceriler: Microsoft Outlook, Uygulamalar için Visual Basic, Visual Basic, Excel, VB.NET

Daha fazlasını gör: hyperlink vba script outlook, write vba script outlook 2007, vba script write outlook alert, vba script outlook call webservice, outlook 2003 vba save email html, vba create text file save subject outlook, send vba script outlook 2007, outlook custom alerts vba script, outlook rules vba script, outlook vba script convert xml, outlook vba script auto, outlook vba script forward, outlook gmail vba script, outlook 2010 vba script, vba script auto forward outlook, outlook vba script, vba script auto forward incoming emails outlook gmail, forwarding vba script outlook, outlook change vba script

İşveren Hakkında:
( 0 değerlendirme ) Tauranga, New Zealand

Proje NO: #20381615

Bu iş için 26 freelancer ortalamada $413 teklif veriyor


Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Daha Fazla

$500 NZD in 7 gün içinde
(321 Değerlendirme)

Hello, I can either write the required VBA script or develop a professional NET outlook Addin to update the sequential number as you mentioned. There is an efficient way to achieve this than reading all the sent items Daha Fazla

$500 NZD in 2 gün içinde
(114 Değerlendirme)

Hi, there! My name is Paris, and I was glad to see that you're looking for a VBA developer. According to your brief, you want to have a routine to check the last sequential number of a project whenever an email is sent Daha Fazla

$380 NZD in 5 gün içinde
(214 Değerlendirme)

Hello? Nice to meet you. I am excited to work with you on this project. I am ready to start work immediately. This is what i have done in Excel/Word/PPT/Access/VBA/MACRO. Just Creating forms, query, Macro, custom f Daha Fazla

$555 NZD in 10 gün içinde
(86 Değerlendirme)

Greetings sir, I have read your project details and i will develop the outlook vba script/plug-in/addin that will add sequence to subject line base on last sent sequence number. Sir, i can deliver this project so Daha Fazla

$500 NZD in 2 gün içinde
(115 Değerlendirme)

Hello there, I have developed more than 500 VBA macros for Windows/MAC I am an expert in Excel/Word/PowerPoint/Outlook VBA/Python with over 5+ years of experience. Ping me to discuss project , timeline and budget. T Daha Fazla

$250 NZD in 2 gün içinde
(177 Değerlendirme)

We can do this in VB Script. Please pm me for more details and sample as well. Hi Mr. Employer I have lot of experience in Access and I can do this project in effective manner with 100% accuracy report to your requirem Daha Fazla

$250 NZD in 6 gün içinde
(79 Değerlendirme)

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] Daha Fazla

$250 NZD in 2 gün içinde
(109 Değerlendirme)

Hi there, I am interested in the project. I have reviewed the requirement and I am sure I can provide you the exact solution you are looking for. Thank You.

$350 NZD in 3 gün içinde
(31 Değerlendirme)

Hello. Nice to meet you. I have good skills in "Excel, Microsoft Outlook, VB.NET, Visual Basic, Visual Basic for Apps", so that i 'm very interest to your project. I have checked description of your project "Outlook Daha Fazla

$250 NZD in 3 gün içinde
(13 Değerlendirme)

I have extensive experience in VBA coding in Outlook. I can easily implement the desired algorithm that you have outlined above. I would recommend having an external txt file keep a list of the most recent emails sent Daha Fazla

$300 NZD in 7 gün içinde
(10 Değerlendirme)

Hello. Below are examples of similar projects done by me recently: Automatic mail items change: https://www.freelancer.com/projects/excel/Microsoft-Outlook-Email-SMS-rule/reviews Script working with shared folders and Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% NZD
(25 Değerlendirme)

Hi there, I have over 20 years experience writing vba applications. In this instance you want to use the application_senditem event to capture when an item is sent from excel. I would tend to steer away from cycling Daha Fazla

$444 NZD in 4 gün içinde
(6 Değerlendirme)

Can do this for your with some simple VBA code. The sending part of the email is limited in Outlook for good reason however. I do not see your attachment however so I'd like to speak to you some more about this. This d Daha Fazla

$400 NZD in 7 gün içinde
(2 Değerlendirme)

Dear Sir or Madam: I am an Expert VBA programmer. I offer the right script to accomplish the desired task. VIP services with MP4 and PDF reference docs, online support. I am interested in doing the job. ASAP guarantee Daha Fazla

$250 NZD in 4 gün içinde
(2 Değerlendirme)

Ready to develop the VBA code to populate subject line beginning with the sequential by the logic you described For skill level and reference you can check my freelancer profile reviews and portfolio of work Regar Daha Fazla

$500 NZD in 5 gün içinde
(1 Yorum)

Hello How are you? I've read carefully your job description. I have more than five years experience in Development. Your satisfaction with the project is my top priority! If you give me a chance to work with you, the Daha Fazla

$500 NZD in 7 gün içinde
(1 Yorum)

Hi, I've done similar to this in a couple of previous projects (IT ticket systems). It can either check your Sent folder or a log. The log may be the best option if Sent folder is large. Any Qs ask! Relevant Skills Daha Fazla

$250 NZD in 3 gün içinde
(0 Değerlendirme)

Hi Sir/Madam, I hope you are doing great. I have gone through the details, After the first look at the description the job looks pretty much doable. I have rich experience with Excel, Microsoft Outlook, VB.NET, Visual Daha Fazla

$555 NZD in 11 gün içinde
(0 Değerlendirme)

Respected Sir, Greetings of the Day ! I am Subham Das. I have 9+ years of competitive experience in web application development using asp.net web form and SQL server. I have 7+ years of experience in Database devel Daha Fazla

$500 NZD in 15 gün içinde
(0 Değerlendirme)