Reply with custom form & selected data from message body

  • Thread starter R3JlZ29yeUwuW0FJVEld
  • 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
 
S

Sue Mosher [MVP]

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

>
 
R

R3JlZ29yeUwuW0FJVEld

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
> >


>
 
S

Sue Mosher [MVP]

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
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
K Extract email address from body and auto-reply outlook Using Outlook 1
T In-line reply style in Outlook Outlook VBA and Custom Forms 20
Vijay Reply all by attachment name Using Outlook 10
N Lookup Value From Excel and Reply With Matching Value Using Outlook 0
G Outlook 2016: reply icon not showing when replied from mobile Using Outlook 3

Similar threads

Top