I have the following code which works great at importing the emails, the only issue is the entire body is put in column D.
What I would like is for the code to import from outlook based on the subject line & then after each new line break add the text to the next column till it is completed. So this is the body of the email that comes out to me:Please Login or Register to view this content.
Due to an Order Entry error we are requesting your assistance with completing a manual move as noted below:
-- SSC Section --
Requesting Agent: Ray Webber
Agent Tier: 1
Agent's Supervisor: Steven Morgan
Offbooks Needed?: Yes
Description of Error:
RTS time stamped in OE but it never left the customers property
**TSA/ART - For your convenience, the link to the specific item is here.**
-- Market / Location Section --
Customer Number: 123456789
Customer Name: Harry Smith
Customer Phone Number: 123-456-7891
Order #: 123456
Container: 28BX2
Market: Chicago IL
Type of Service Requested: Return to Storage
Date Needed: 5/8/2019
Summary of Action Needed:
customer need time stamp removed
Move To (Service) Address:
storage center
Move From Address:
123 ABC Parkway, Bolingbrook, IL 60440 [USA]
Complex: N/A
Facing: Container door faces the building - Rear
Street, Driveway or Parking Lot: In a private driveway
Circular or Straight Driveway?: A straight 1 car
Which side of the driveway?: N/A
How far away from building/landmark?: 6 feet | Specific Distance (if appl): N/A
Special Directions:
Special Instructions: N/A
Is this a gated community? No
Gate Code or Instructions (If applicable):
Cross Street 1: US 34
Cross Street 2: South Eol Rd
I have uploaded my workbook for any assistance you can provide. Thank you for any help in advance!
Bookmarks