Dear Team,
Hope you are doing great.
I have 1 requirement where i need to prepare word doc letter and send to all finance manager through outlook as attachment.
I have written macro code for the same which is working fine but i have additional requirement in this code is where supplier Name and address should come in "Text Box" as shown below and not typed as normal which should come after To Finance Manager .
To Finance Manager,
«Supplier_Name»
«Supplier_Address»
Dear Sir/Madam
We regret that we are unable to process the below referred invoice for the following reason:
«Rejection_Reason»
Accenture Ref: «URN»
Invoice Number: «Invoice_Number»
Invoice Date: «Invoice_Date»
Invoice Amount: «Invoice_Amount»«Currency_code»
Correct Details:
«Last_Comment»
Request you to kindly amend your invoice accordingly and resend it to us at
«DFM_Email_id» as soon as possible.
If you have any queries please do not hesitate to contact customer support at
«Customer_care».
Yours sincerely
Below is the VBA code i have written which is working fine except the Name and address not coming in TextBox.
Please help me with VBA code i should put to have Name and address in Text Box in Word Document.
Thanks
Bookmarks