Outlook Mailbox VBA script

Cerrado Publicado hace 4 años Pagado a la entrega
Cerrado Pagado a la entrega

Brief:

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

Detail:

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.

Microsoft Outlook Visual Basic para aplicaciones Visual Basic Excel VB.NET

Nº del proyecto: #20381615

Sobre el proyecto

22 propuestas Proyecto remoto Activo hace 4 años

22 freelancers están ofertando un promedio de $418 por este trabajo

schoudhary1553

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. Más

$500 NZD en 7 días
(489 comentarios)
8.4
paris2785

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 Más

$380 NZD en 5 días
(452 comentarios)
8.3
maverick44000

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 Más

$500 NZD en 2 días
(123 comentarios)
7.7
avinav606lx

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 Más

$250 NZD en 2 días
(179 comentarios)
6.6
Sercho56

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 Más

$300 NZD en 7 días
(41 comentarios)
6.1
DebasisB

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 en 3 días
(36 comentarios)
5.6
vw64901vw

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 Más

$444 NZD en 4 días
(6 comentarios)
2.8
rstrandmark

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 Más

$400 NZD en 7 días
(2 comentarios)
2.2
vw1514518vw

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 Más

$500 NZD en 5 días
(4 comentarios)
2.3
tsft

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 Más

$250 NZD en 4 días
(2 comentarios)
1.9
maxmani373

hi, i can provide you with this mail script according to your description we have commend in creating intelligent script and system through machine learning techniques. send me mag and get started with it. thanks

$1000 NZD en 50 días
(1 comentario)
0.6
SmithZhang

Dear sir. How are you? I am a Web expert that have rich experience for 7+ years. I have read your description carefully and I am interested in the task. I have confidence that I can do perfectly it. I’m looking forwar Más

$500 NZD en 1 día
(0 comentarios)
0.0
laibailyas

Hello there, How are you doing? I have read the description, I have great experience doing similar jobs related to these skills Excel, Microsoft Outlook, VB.NET, Visual Basic, Visual Basic for Apps. Right now I am p Más

$555 NZD en 5 días
(0 comentarios)
0.0
amnailyas1

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 Más

$555 NZD en 11 días
(0 comentarios)
0.0
UnrealJoshua

Hi there! My name is Joshua, a Software Engineer from Australia. I have a Bachelor of Computer Science and have been working for four years professionally. I'm new to freelancing but very experienced for this kind of Más

$250 NZD en 3 días
(0 comentarios)
0.0
Sharper1234

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 Más

$250 NZD en 3 días
(0 comentarios)
0.0