473,386 Members | 1,832 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

Can't figure out If...then

I'm trying to set up a mailmerge with an access file, using Windows Vista and -- I'm not even sure, whatever the newest Office is,

I need to put an If...then command into the Salutation Line. It needs to say Dear (Title) (LastName)

followed by if LastName2 is not blank

I want to enter and (Title2) (LastName2),


else

just enter a comma


When I open up the "Rules" window for If...then, I get a window in which I am supposed to insert the text if the parameters are met. But I can't insert fields in that window, I can type in "and," but then I can't select "insert merge field," and if simply type in << followed by the name of the field, followed by >> , that doesn't work. What do I do?
Jul 16 '07 #1
1 942
I'm trying to set up a mailmerge with an access file, using Windows Vista and -- I'm not even sure, whatever the newest Office is,

I need to put an If...then command into the Salutation Line. It needs to say Dear (Title) (LastName)

followed by if LastName2 is not blank

I want to enter and (Title2) (LastName2),


else

just enter a comma


When I open up the "Rules" window for If...then, I get a window in which I am supposed to insert the text if the parameters are met. But I can't insert fields in that window, I can type in "and," but then I can't select "insert merge field," and if simply type in << followed by the name of the field, followed by >> , that doesn't work. What do I do?



It's Office 2007 -- just checked.
Jul 16 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: frank.baris | last post by:
I usually can figure out anything by searching the groups or the net all day, but this problem has been bugging me for awhile now. I have multiple databases, all of which have the same 2 tables,...
10
by: MHenry | last post by:
Hi, We were going merrily along for 6 years using this database to record all client checks that came into our office, including information about what the checks were for. Suddenly, network...
102
by: Skybuck Flying | last post by:
Sometime ago on the comp.lang.c, I saw a teacher's post asking why C compilers produce so many error messages as soon as a closing bracket is missing. The response was simply because the compiler...
3
by: john | last post by:
I don't want to know what the CPU utilization is right now. I want to get the average utilization over the last, for example, hour. So I came up with a method where I would get a Process object...
0
by: Ken Dopierala Jr. | last post by:
Hi, I know this post will be considered off-topic. There are a lot of good coders in these groups and I'm hoping someone can help me out. This is what I'm working on. I used to use the...
1
by: Locke | last post by:
I know I'm doing something wrong, and it's something simple but I can't figure it out. I'm new at this and it's only a little more than a hobby so please bear with me. I'm writing a VB shell...
9
by: Tony Girgenti | last post by:
Hello. I'm developing and testing a web application using VS.NET 2003, VB, .NET Framework 1.1.4322, ASP.NET 1.1.4322 and IIS5.1 on a WIN XP Pro, SP2 computer. I'm using a web form. For a...
52
by: MP | last post by:
Hi trying to begin to learn database using vb6, ado/adox, mdb format, sql (not using access...just mdb format via ado) i need to group the values of multiple fields - get their possible...
1
by: Leonnhy | last post by:
HI, I'm a beginner in using MS Access. What's the code for the bring forward figure in current sales report I create as follows:- Once I click on the sales report, it will show me the date range...
0
by: Frank | last post by:
Hi, I use rpy to plot functions and have the following problem. When I execute the following code line by line (start python and then execute line by line) the resulting figure looks as it...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.