Reply with custom form & selected data from message body

  • Thread starter Thread starter R3JlZ29yeUwuW0FJVEld
  • Start date Start date
Status
Not open for further replies.
R

R3JlZ29yeUwuW0FJVEld

Hi everyone,

I receive a lot of plain text emails that contain data in a preset format

that I would like to auto reply with a custom form I have built. I would like

to know if I can locate and use certain values from the original message in

my reply (e.g. original msg contains as plain text First Name: John and

Coffee Type: Arabica. Can I locate John and Arabica in the original msg and

populate those values in my auto reply form -> Hi John, thanks for your

enquiry about our Arabica coffee range...)

It seems straight forward enough yet any help or pointers in the right

direction would be greatly appreciated.

TIA

Greg
 
You might find this code sample useful:

http://www.outlookcode.com/codedetail.aspx?id=89 It shows how to parse a

structured text block as your scenario describes.

Sue Mosher

"GregoryL.[AITI]" <GregoryL.[AITI]> wrote in

message news:2C54185E-4A80-4943-AC42-B9E7C1D7EE8B@microsoft.com...
> Hi everyone,

> I receive a lot of plain text emails that contain data in a preset format
> that I would like to auto reply with a custom form I have built. I would
> like
> to know if I can locate and use certain values from the original message
> in
> my reply (e.g. original msg contains as plain text First Name: John and
> Coffee Type: Arabica. Can I locate John and Arabica in the original msg
> and
> populate those values in my auto reply form -> Hi John, thanks for your
> enquiry about our Arabica coffee range...)

> It seems straight forward enough yet any help or pointers in the right
> direction would be greatly appreciated.

> TIA

> Greg

>
 
Thanks Sue for the pointers and links, I'm almost there!

The example at

http://www.outlookcode.com/threads.aspx?forumid=2&messageid=696 is very close

to what I'm dealing with except the data value attached to each label is on

the line below it - see example...

<snip
Q. Email Address

A. John_Smith@domainname.com

Q. First Name

A. John

Q. Coffee Type

A. Arabica

<snip
I can successfully locate & return the Email Address label, how do I go the

next step and get the code to locate the label but return the line below it

for trimming and insertion into my reply email?

TIA -Greg

"Sue Mosher [MVP]" wrote:


> You might find this code sample useful:
> http://www.outlookcode.com/codedetail.aspx?id=89 It shows how to parse a
> structured text block as your scenario describes.

> > Sue Mosher
> > >

> "GregoryL.[AITI]" <GregoryL.[AITI]> wrote in
> message news:2C54185E-4A80-4943-AC42-B9E7C1D7EE8B@microsoft.com...
> > Hi everyone,
> > I receive a lot of plain text emails that contain data in a preset format
> > that I would like to auto reply with a custom form I have built. I would
> > like
> > to know if I can locate and use certain values from the original message
> > in
> > my reply (e.g. original msg contains as plain text First Name: John and
> > Coffee Type: Arabica. Can I locate John and Arabica in the original msg
> > and
> > populate those values in my auto reply form -> Hi John, thanks for your
> > enquiry about our Arabica coffee range...)
> > It seems straight forward enough yet any help or pointers in the right
> > direction would be greatly appreciated.
> > TIA
> > Greg
> >


>
 
I'd use the same text parsing functions, Instr() and Mid(). Use Instr() to

search for the text "Email Address", then from that starting position,

search for the text "A:", etc. Use Mid() to clip the text.

Sue Mosher

"GregoryL.[AITI]" <GregoryLAITI> wrote in message

news:0E2CF2B3-3851-4092-B0FF-F5E5384F28D0@microsoft.com...
> Thanks Sue for the pointers and links, I'm almost there!

> The example at
> http://www.outlookcode.com/threads.aspx?forumid=2&messageid=696 is very
> close
> to what I'm dealing with except the data value attached to each label is
> on
> the line below it - see example...

> <snip
> Q. Email Address
> A. John_Smith@domainname.com

> Q. First Name
> A. John

> Q. Coffee Type
> A. Arabica
> <snip
> I can successfully locate & return the Email Address label, how do I go
> the
> next step and get the code to locate the label but return the line below
> it
> for trimming and insertion into my reply email?

> TIA -Greg

> "Sue Mosher [MVP]" wrote:
>
> > You might find this code sample useful:
> > http://www.outlookcode.com/codedetail.aspx?id=89 It shows how to parse a
> > structured text block as your scenario describes.
>

>> "GregoryL.[AITI]" <GregoryL.[AITI]> wrote in
> > message news:2C54185E-4A80-4943-AC42-B9E7C1D7EE8B@microsoft.com...
> > > Hi everyone,
> >> > I receive a lot of plain text emails that contain data in a preset
> > > format
> > > that I would like to auto reply with a custom form I have built. I
> > > would
> > > like
> > > to know if I can locate and use certain values from the original
> > > message
> > > in
> > > my reply (e.g. original msg contains as plain text First Name: John and
> > > Coffee Type: Arabica. Can I locate John and Arabica in the original msg
> > > and
> > > populate those values in my auto reply form -> Hi John, thanks for your
> > > enquiry about our Arabica coffee range...)
> >> > It seems straight forward enough yet any help or pointers in the right
> > > direction would be greatly appreciated.
> >>> > TIA
> >> > Greg
> >>> >

>

>
>>
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
P Reply / forward with a custom form. Outlook VBA and Custom Forms 1
T Custom Appointment Form Message Body Deleted upon reply. Outlook VBA and Custom Forms 3
L reply to message using a custom template Using Outlook 1
B Reply to All custom action doesn't work with attachments in Outlook 2007 Using Outlook 1
B Custom Properties or Reply Outlook VBA and Custom Forms 7
G Custom Forms: Attachment to be included in Reply Outlook VBA and Custom Forms 1
G Reply a selected message and remove blank space before signature Outlook 365 version 2406 64BIT Outlook VBA and Custom Forms 2
G Reply a selected message and remove blank space before signature Outlook 365 version 2406 64BIT Outlook VBA and Custom Forms 0
T In-line reply style in Outlook II Outlook VBA and Custom Forms 1
M Simple Reply, Reply All, Forward Outlook VBA and Custom Forms 1
N Reply to Outlook messages by moving messages to a specific Outlook folder Outlook VBA and Custom Forms 1
J Macro to Reply to Emails w/ Template Outlook VBA and Custom Forms 3
J Quick steps delete original email and move reply/sent email to folder Using Outlook 2
nmanikrishnan Auto-reply from default account Using Outlook 1
P Automatic Greeting "Hello Name," when Reply All is clicked Outlook VBA and Custom Forms 1
N Line to move origEmail to subfolder within a reply macro Outlook VBA and Custom Forms 0
A Outlook 2016 Macro to Reply, ReplyAll, or Forward(but with composing new email) Outlook VBA and Custom Forms 0
S How to find emails that I sent that have not received a reply? Using Outlook 7
T Macro to move reply and original message to folder Outlook VBA and Custom Forms 6
A Is there an ID field you can use to pair a reply to the sent email? Outlook VBA and Custom Forms 4
W Reply to email Using Outlook 4
A Edit attachment Save and Reply Outlook VBA and Custom Forms 0
L Macro/VBA to Reply All, with the original attachments Outlook VBA and Custom Forms 2
S Outlook Macro to move reply mail based on the key word in the subjectline Outlook VBA and Custom Forms 0
diver864 vba for a rule to automatically accept meeting requests with 'vacation' in subject, change to all-day event, change to free, don't send reply Outlook VBA and Custom Forms 1
B Adding signature to bottom of VBA reply email Outlook VBA and Custom Forms 1
C UDFs Reply vs Forward Outlook VBA and Custom Forms 3
ThinkToday Calculate reply time of outlook mail Using Outlook 1
W Replyin to the reply-to email address Outlook VBA and Custom Forms 0
D Reply with a template loose the sender's embedded image Outlook VBA and Custom Forms 0
R List folders in a combo box + select folder + move emails from inbox to that folder + reply to that email Outlook VBA and Custom Forms 1
J Outlook Reply > From > Other Email Address... > Address Not Showing in Sent Items... From Email Outlook VBA and Custom Forms 0
M Delete headers in Inline reply Outlook VBA and Custom Forms 5
E reply Using Outlook 0
Healy Consultants Macro to remove inside organization distribution list email address when reply to all recepients Outlook VBA and Custom Forms 0
B resend if no reply and send an automatic reminder Outlook VBA and Custom Forms 0
evdbogaard Reply with only last message cited Using Outlook 1
B Reply and replyall macro is not working Outlook VBA and Custom Forms 1
mctabish Setting "Reply To" based on inbox Outlook VBA and Custom Forms 2
Rupert Dragwater Deleted email address keeps showing up in reply Using Outlook 12
B When working on emails in a certain folder, when I hit reply or reply all, I would like it re always reply all and add an email address to send to Outlook VBA and Custom Forms 3
R How Do I insert images in and Auto Reply Using Outlook 3
D Disable or hide "reply" and "reply to all" and "forward" in email from access vba Outlook VBA and Custom Forms 1
M Reply Inline With a Outlook Template Outlook VBA and Custom Forms 6
broadbander Needing help with reply/reply all while keeping attachments and adding a new CC recipient. Outlook VBA and Custom Forms 5
O On click,I want to change subject line of selected mail and then reply to particular email and move Using Outlook 3
J VBA Run When Reply Outlook VBA and Custom Forms 4
D Font in Reply is much larger than normal, how to reset ...? Using Outlook 4
K add pdf to every reply or forward Outlook VBA and Custom Forms 1
A VB to "reply all" email items stored in a folder of outlook with adding a new message Outlook VBA and Custom Forms 0

Similar threads

Back
Top