moving the email templates from Excel to Word document

rk68 · Sep 23, 2019

Hi,

I have multiple Email templates in Excel. These templates are in each column.
I want this templates to be converted to Word document, so each template will fall in each page.

for e.g. if there are 5 templates in 5 columns (Column A - E). Content of column A will page 1 of Word doc,content of column B will be page 2 & so on. I have attached sample file for reference.

How can this be done using VBA.

TIA,
RAJ

Andrzejek · Sep 23, 2019

So you have an Excel file that looks like this:
[pre]
A B ...
1 Product sub-category
2 Health Appointment fixed
Checkups Cancelled
Rescheduled
3 ... [/pre]

How do you want it to have in Word?
Cells A1 and A2 on first page? B1 and B2 on second, and so on...?

And what does it have to do with "e-mail templates"?

BTW - If you are looking for a VBA solution, you should ask your question in forum707

---- Andy

There is a great need for a sarcasm font.

rk68 · Sep 24, 2019

Hi Andy,
I have attached a doc file FYR.
It should something similar. If possible each of the column content can fall in separate page.

Thanks,
RAJ

rk68 · Sep 24, 2019

I did manage it without VBA/macros.

Thanks.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

moving the email templates from Excel to Word document

rk68

Programmer

Andrzejek

Programmer

rk68

Programmer

rk68

Programmer

Similar threads

Part and Inventory Search

Sponsor