bigal.nz
11-24-2014, 09:41 AM
Morning VBA peoples,
I need to make one big string from each row in a table, then past that big string into each row in a Outlook template.
The logic would be something like:
For each row in ActiveDocument.Table(3) 'Starting at Row 3
BigString = String.Column1 & String.Column2 & String.Colum3 & String.Colum4
Insert BigString in OutlookTemplateObject.Table(1).Column3
Loop Next Row ActiveDocument.Table(3) Until End of Rows
This may seem simple but I haven't used VBA for a while and my skills are rusty.
I have my outlook template open OK.
Its really just the loop that was throwing me.
ActiveDocument.Table(3) is fixed at 4 colums with two header rows (hence start at row3).
The Outlook table is also fix at 3 columns, no header row. I dont need to insert rows as I go since the outlook table has been made to be more than long enough.
Thanks in advance,
-Al
I need to make one big string from each row in a table, then past that big string into each row in a Outlook template.
The logic would be something like:
For each row in ActiveDocument.Table(3) 'Starting at Row 3
BigString = String.Column1 & String.Column2 & String.Colum3 & String.Colum4
Insert BigString in OutlookTemplateObject.Table(1).Column3
Loop Next Row ActiveDocument.Table(3) Until End of Rows
This may seem simple but I haven't used VBA for a while and my skills are rusty.
I have my outlook template open OK.
Its really just the loop that was throwing me.
ActiveDocument.Table(3) is fixed at 4 colums with two header rows (hence start at row3).
The Outlook table is also fix at 3 columns, no header row. I dont need to insert rows as I go since the outlook table has been made to be more than long enough.
Thanks in advance,
-Al